Service Portal Report List & Report Form Widgets
ServiceNow reports are not OOTB available in current release of service portal. There are couple of hints you can find in community articles or a solution available in share in relation to reports but none of them provide a complete end to end solution. Hence to fulfill this need I have developed two widgets as below:
1) Report List
This widget will display a list of all the reports that a user can see based on security configured in report i.e. depending on their role or group.
User can easily add this widget to appropriate position on portal and then CTRL+Click on widget to configure instance options.
Following options are available to configure this widget.
Number of reports to show: This option will allow display of reports in the list upto given number. This is to ensure that incase of many reports this widget does not appear oversized in height as compared to other widgets on the portal. If reports are more than the given number a 'Show all' link will be displayed at the bottom.
Show Back to Home: This option will allow display of 'Back to Home' button on full reports list which is displayed when 'Show all' link is clicked on widget from portal home page.
Filter: This will allow filtering of reports displayed in the widget, i.e. to display reports only related to Incident table you could use appropriate encoded query.
Sort by: (Under construction) By default reports are sorted in the list based on most recently run on top to rarely or never run reports towards the end of list. It would also display the time when this report was last ran. I am looking to provide more sorting options in future release of this solution.
1) Report Form
This widget will display the report, which was clicked on reports list widget.
User can CTRL+Click next to 'Back to Home' button on widget to configure instance options. i.e.
Height: User can configure height of report being displayed.
Back to: (Under Construction) I am looking to provide option for navigating back to any other page in future release.
To implement this solution please download attached update set, review & commit it.
Please share your feedback / comments or report any issues to me at syed.faheem@servicenow.com
https://www.servicenow.com/community/now-platform-articles/service-portal-report-list-report-form-widgets/ta-p/2321613