Export report shows sys_id instead of display name

Prateek kumar
Mega Sage

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:

find_real_file.png

Report in ServiceNow:

find_real_file.png

Any help would be greatly appreciated


Please mark my response as correct and helpful if it helped solved your question.
-Thanks
1 ACCEPTED SOLUTION

There is a system property that needs to be changed to export the display values.

Set Use Label to true

find_real_file.png


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

8 REPLIES 8

There is a system property that needs to be changed to export the display values.

Set Use Label to true

find_real_file.png


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

hi Prateek Kumar,

can you help to text which properties? i am not found the properties.

find_real_file.png

go to the system properties >> Import export module >> there you will find the properties related to csv , excel xml etc.

thanks, it's helpfull