How to dot walk RITM variable in report

[JK9903]

Hello Everyone,

I want a report that shows the submitted catalog item details. In that catalog item, I have two reference variables user and group. I am able to get the variables in the report, but I want to dot-walk the reference to retrieve the email and display it in the report. However, I am unable to dot-walk the variable.

[James271Riv]

Hello!

In ServiceNow, you can’t directly dot‑walk catalog item variables in reports because they’re stored in separate variable tables, not as native reference fields on the RITM. To show details like a user’s email, you need to either build the report on the variable tables and join them back to the request item, or use scripting/Flow Designer to pull the reference variable and then dot‑walk to the email field. In short, standard report dot‑walking won’t work on catalog variables—you’ll need to query variables separately or script the lookup. 

[Mark Manders · Accepted solution]

Your variable isn't an actual field, so you can't dotwalk there. You can add the 'email' as a hidden variable on the catalog item and have it auto filled (no scripting needed). Then you can just show the email variable as well on your report.

[Tanushree Maiti]

I second with @Mark Manders  . In report , on variable -you can not dot walk.

My recommended solution is same as Mark with taking hidden variable and store the variable as per your requirement. Use that hidden variable in your reporting.

[Ankur Bawiskar]

@JK9903 

You can't dot walk like that

you can try to create a database view joining 3 tables and your User and Group table then create report on that database view table

Then include the Email columns in report

See if that works

Report on Item Variables in the Service Catalog with a Database View 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏