Sample Report Listing The Dashboards That are Using Web Content (For PostgreSQL DB)

Users can use JasperReports Server (JRS) to create a dashboard and use a dashlet to display web content on the dashboard. Refer to JRS User Guide

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v790/adding-new-content

"Adding a Web Page"

Notice the web resources from remote domains that are not accessed under the same server domain hosting JRS deployment will by default get blocked for cross domain violation. In such a case, JRS dashboard will not be able to display those web resources unless they are whitelisted by the system configuration. 

Refer to JRS Security Guide

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v790/configuring-csrf-protection

Despite the CSRF protection, if the system administrators have concerns over what web contents the users might put into the dashboards, they can run the sample report to list those dashboards and the dashlet URLs to review those web resources.

Please download the "export-50. List of Dashboard Using Web Content.zip" file from the attachment and have it imported into your JRS 8.0 repository DB using the legacy key. Users also need to download the modified security.properties and validation.properties files and put them into deployed jasperserver-proWEB-INFclassesesapi folder to replace the original ones, and restart the server, to test run the "50. List of Dashboard Using Web Content" under publicSamplesReports repository folder to get the dashboard list.

Users can also click on the web resource URL in the report to review its content in a new browser tab.

High Level Report Design Discussion

Repository tables involved in the report

jidashboardmodelresource

jifileresource

jiresource

jiresourcefolder

Technique used in the report

• Use PostgreSQL encode function to decode dashlet component information from a binary Blob into a text string
• Use recursive subreport execution to traverse the dashlet component text string to locate and display multiple web resources in the dashboard

Disclaimer

This sample report is provided AS IS therefore it is not supportable.

===============================================

TTC-20220614

export-50._list_of_dashboard_using_web_content.zip

security.properties

validation.properties