post Service Portal Report List & Report Form Widgets in ServiceNow AI Platform articles

Service Portal Report List & Report Form Widgets

syed_faheem — Tue, 06 Dec 2016 06:18:55 GMT

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

Re: Service Portal Report List & Report Form Widgets

katyaomni — Sun, 21 May 2017 15:15:23 GMT

Has anyone tried this update set, as for me it gives error not valid xml? please advise?

Re: Service Portal Report List & Report Form Widgets

syed_faheem — Mon, 22 May 2017 00:44:31 GMT

Hi Katya

Did you try V1.1 ? is it still giving you issues ?

Re: Service Portal Report List & Report Form Widgets

Sheetal7 — Thu, 25 May 2017 06:42:27 GMT

Hi Syed,

Thanks for article.It was realy useful.

I have requirement to show Multilevel Pivot report on portal.Could you let me know if we have any widgets which can be used to serve the requirement.

Regards

Sheetal

Re: Service Portal Report List & Report Form Widgets

Allison3 — Thu, 25 May 2017 12:40:37 GMT

I tried to download this and am getting an error: File sys_remote_update_set_88b80f6f4fe7a200df2b5a701310c7bb (1).xml is not valid XML and has been deleted

Re: Service Portal Report List & Report Form Widgets

katyaomni — Thu, 25 May 2017 12:45:54 GMT

I get the same too.

Katya Lewis

Re: Service Portal Report List & Report Form Widgets

syed_faheem — Wed, 07 Jun 2017 01:03:56 GMT

Please use version 1.2 from ServiceNow Share

Re: Service Portal Report List & Report Form Widgets

syed_faheem — Wed, 07 Jun 2017 01:04:15 GMT

Please use version 1.2 from ServiceNow Share

Re: Service Portal Report List & Report Form Widgets

Patrick Schulte — Fri, 09 Jun 2017 13:11:59 GMT

You guys might also wanna take a look at this:

https://codecreative.io/servicenow/intro-to-highcharts-in-service-portal

Re: Service Portal Report List & Report Form Widgets

sagarsharma — Tue, 27 Jun 2017 08:03:41 GMT

Hi syed.faheem I dont have Hi Credentials, could you please share any other link where I can download this update set or if possible please sent it on my email id: oceanwizard@hotmail.com.

Thanks in Advance.

Sagar Sharma

Re: Service Portal Report List & Report Form Widgets

Sharashk — Fri, 30 Jun 2017 18:00:24 GMT

I allowed end user to access the demand table using read ACLs and created a report for them to view on this widget. Looks like this cannot be used in Production. The territory manager for our instance says this warrants a license. The purpose of this widget is hence defeated. Not sure if anyone else has this issue or is it based off customer agreements.

I am still puzzled how different is this from say "Publish a report to be available for public" OR Scheduled report of the same data sent through an email.

Overall, disappointed that this couldn't add value to the customer we are supporting.

Re: Service Portal Report List & Report Form Widgets

chaitusnow — Mon, 07 Aug 2017 13:03:30 GMT

Hi Syed,

Does the Reports in Servie Portal have Drill Down feature?

When i click on the report which is displayed in the service portal. The report should be drill down, The list view should be visible.

Re: Service Portal Report List & Report Form Widgets

Bhanuchander Ga — Mon, 25 Jun 2018 11:06:47 GMT

Hi Syed,

Thanks for the solution, now i can able to create this widget in my instance.

But i also need Create report option in the widget can you please help me on this.

Thanks and Regards

Bhanuchander

Re: Service Portal Report List & Report Form Widgets

Brian S5 — Tue, 15 Jan 2019 20:42:03 GMT

Syed,

Are you still maintaining this widget ? The under construction section shows you were working on a sort function, were you able to get that part figured out ? I posted on the discussion thread, but not sure if this is still being updated. Let me know. Thank you.

Re: Service Portal Report List & Report Form Widgets

ayano — Thu, 04 Nov 2021 00:19:06 GMT

Hi,

I want to use this update set, but I can't find the link.

Is it still a valid widget?

If you don't mind, I would like to have an update set.

Regards,

Re: Service Portal Report List & Report Form Widgets

syed_faheem — Thu, 04 Nov 2021 01:37:13 GMT

Hi Ayano,

It seems like the link to the location has broken. I have attached the update set with this post.

Cheers

Syed.

Re: Service Portal Report List & Report Form Widgets

ayano — Thu, 04 Nov 2021 02:43:24 GMT

Thank you for the file.

I got an error when I tried to apply it to my instance.

What should I do?

Re: Service Portal Report List & Report Form Widgets

ayano — Thu, 04 Nov 2021 06:06:11 GMT

@syed.faheem

If you have any suggestions, please share.

Regards,

Re: Service Portal Report List & Report Form Widgets

ayano — Mon, 08 Nov 2021 05:02:34 GMT

@syed.faheem

If you have any suggestions, please share.

Regards,

Re: Service Portal Report List & Report Form Widgets

Veronica3 — Tue, 16 Nov 2021 11:50:19 GMT

Hi Syed,

Thank you for your solution, I have taken your update set and it works.
I have one need though, I need to display your widgets on the Now App Mobile, but the "Form report" widget is not mobile responsive. Do you know how to make it responsive?
I attach you how it looks from mobile.