Report and Dashboard

bichvu2307
Tera Contributor

Hi All,
Hope you are doing well,

Could you please let me know if we can find a list of reports included in each dashboard?

Best Regards,
Anna

@Tai Vu 

1 ACCEPTED SOLUTION

SK Chand Basha
Giga Sage

HI @bichvu2307 

Navigate to Admin Console. Click on "Dashboards"

In the "Dashboards" window, click on the top left drop down, and switch from default "Dashboard Groups" to "Dashboards".  On the tabs below, click on "Report" tab.

This should show you the list of all the reports being used for a particular dashboard.  You can export the result to a report.

 

Mark helpfull and accept the solution .If this helps you to understand.

 

 

View solution in original post

3 REPLIES 3

Mark Manders
Mega Patron

There isn't an OOB way to do that. That would take custom scripting, using tables like sys_portal_page, sys_dashboard and sys_report. 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

SK Chand Basha
Giga Sage

HI @bichvu2307 

Navigate to Admin Console. Click on "Dashboards"

In the "Dashboards" window, click on the top left drop down, and switch from default "Dashboard Groups" to "Dashboards".  On the tabs below, click on "Report" tab.

This should show you the list of all the reports being used for a particular dashboard.  You can export the result to a report.

 

Mark helpfull and accept the solution .If this helps you to understand.

 

 

AndersBGS
Tera Patron
Tera Patron

Hi @bichvu2307 ,

 

As @Mark Manders has described, there is no OTTB way to do this. You could create a database view as below:

AndersBGS_0-1712263112746.png

Notice, that order 600 --> 1100 is not needed in your case, and order 1300 can be changed to rep.sys_id = repstat.report_sys_id.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

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/