two tables fields to display in a one report for Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 11:08 AM
I have 2 tables which contains different fields but I want to merge them in a single report and display it as a dashboard
table1 - field1, field2
table2 - field3, field4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 12:09 PM
Hi @Kri
you can create a database view for creating a report which will show the different fields value in a single report.
Please mark this as helpful and accept it as a solution if this works for you.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 12:32 PM
I don't have a common fields in these 2 tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2024 12:43 PM
@Kri You can create a field which will refer to the other table and then you can create a database view.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-16-2024 01:25 PM
Hi @Kri ,
first of all, if this is two different tables - why would you then merge them into one report? What is the business case for this?
secondly can you give some more information in relation to what the two table contains and what you would like to see in the report? What should X and Y axis contain?
if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anderz
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/