Service Portal Report List & Report Form Widgets

[syed_faheem]

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

[katyaomni]

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

[syed_faheem]

Hi Katya

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

[Sheetal7]

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

[Allison3]

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

[katyaomni]

I get the same too.

Katya Lewis

[syed_faheem]

Please use version 1.2 from ServiceNow Share

[syed_faheem]

Please use version 1.2 from ServiceNow Share

[Patrick Schulte]

You guys might also wanna take a look at this:

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

[sagarsharma]

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

[smk25]

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.

[chaitusnow]

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.

[Bhanuchander Ga]

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

[Brian S5]

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.

[ayano]

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,

[syed_faheem]

Hi Ayano,

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

Cheers

Syed.

[ayano]

Thank you for the file.

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

What should I do?

[ayano]

@syed.faheem 

If you have any suggestions, please share.

Regards,

[ayano]

@syed.faheem 

If you have any suggestions, please share.

Regards,

[Veronica3]

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.