Is there a way to show a report on a catalog item as a link?

[praveenKumar2]

Hi All,

I have a requirement to add an attachment which is live ( Meaning: The user wants a list of approved and rejected tickets as a live report). Example: if the table is sc_req_item and there are approved, rejected and pending tickets. and the report is saved in knowledge and linked to a service catalog. So now when there is any newly updated record that needs to be added to the link automatically.

I tried to add it as a list which shows all the approved tickets list but in a list we can only show 100 as default and we have increased it to 200, But still think that it might increase in future so this approach was not working as per the requirement.

Please suggest me how this can be implemented.

Thanks in Advance.

pK.

[randrews]

if you can create the report that will filter how you want.. you can do it by navigating to the report by url per this article...   the issue is going to be populating the current item in the link... not sure THAT will wrk.. it might be better with a list view using some kind of a query string... are you looking to create this in the catalog or on the requested item??

Navigating by URL - ServiceNow Wiki

[praveenKumar2]

The article needs to be added in Knowledge base and link that record to the catalog item is what i am looking for.

A scheduled job script might be the solution --> which will update the article information on a daily basis and keep the records consistent but i am not sure how to do it

[gyedwab]

Explore Analytics live reports can be embedded in HTML or linked to from a Knowledge article... the data is in real time, but if you change the report you can republish it and it will automatically update the same URL (rather than requiring you to create a new URL).

It can also accept parameterized inputs into the report, so you can pass the current item in the URL.

Best part is this approach requires writing no javascript.

If you're interested in trying it out, you can try it here and I'd be happy to answer questions to help you get the report.

[praveenKumar2]

Thanks for your suggestion but, I do not want any external tools, If i wanted that i would have kept the link in sharepoint and routed it to service now via link. But we want to use Knowledge base and update that attachment on a daily basis.