Export report shows sys_id instead of display name

[Prateek kumar]

Hello Experts

I created a report on RITM table and dot walked to Variables[+] and included the required variables in my report. Now when I trying to export this report to CSV/Excel the report header shows as variable.sys_id. Is this a known error/expected behavior. This is really confusing to the end users since this report is scheduled to the business users.

Exported Report header:

Report in ServiceNow:

Any help would be greatly appreciated

[sachin_namjoshi]

You can follow below to generate RITM variables in report.

REQUESTED ITEM VARIABLES REPORT

Visible to: Everyone
Type: List
Table: Variable Ownership [sc_item_option_mtom]
Group By: Parent Item
 
Columns:
- Parent Item
- Parent Item.Request.Requested For
- Dependent Item.Order
- Dependent Item.Question
- Dependent Item.Value
- Created
 
Filter and Order
- Parent Item.Item is <your item>
- Dependent Item.Value is not empty

Regards,
Sachin

[Prateek kumar]

I cannot ask the business to report on Variable Ownership table, is there no way i can do this method in exporting the list?

[Harsh Vardhan]

it's working and showing me the correct columns name while i tried to export to the excel.

you are on which version?

https://docs.servicenow.com/bundle/istanbul-performance-analytics-and-reporting/page/use/reporting/t...

[Prateek kumar]

It is working in Excel export but not in CSV Version. Btw we are on LONDON