Is there a way to add record reference link in exported excel report?

[RKumar3]

Hi All, I have a requirement wherein I need to export an excel report on problem table. I am able to export the report appropriately except the fact that I am not able to export the link to problem records. I am only getting the Problem record number in the xls but not the reference link so that user can click the reference link directly from the excel and open the problem record in ServiceNow. Anyone has done something like this before? Many thanks in advance. Regards, Rajnish Kumar

[Kalaiarasan Pus]

Is there no way to do this without adding the field ? Maybe using any database view or something ???   We do want this feature but if possible , it would be great without a new field

[Richard78]

Hello Everyone,

I too have had inquiries as to how to have a report that is exported/emailed have links back to the incident that work when you click on the incident number. For Example there is a scheduled report that runs every morning and is sent to management and application teams for our Operations team that lists all the tickets for jobs that ran the previous night and if they are open, resolved, etc.

The purpose of the report is for management to know at a glance what issues occurred and that they were resolved and to allow them to look up the details by going to the ticket if they need to. You can see how management would not want to have to A. search for the ticket or B. click an additional field that maybe makes no sense to them.

I am not so eager to add an additional column to the task or incident table... So I am guessing that other than the table column add with a calculated field there are no other options except opening a Improvement ticket with SN?