Reporting on Catalog item variable

[RadhikaG]

I have one report in servicenow, in which it is created upon a catalog item. It has a variable of the catalog item which is a reference field. now i want that the variable/field we have selected for that also reference field should be visible.?

for eg. mirror access is field in catalog item. i have this variable in report and mirror access is referenced field. In the mirror access user is mentioned. i want the title, department,employee number, manager of that user also included in the report.

[Tanushree Maiti]

Hi @RadhikaG 

refer: 

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

Reporting on Catalog item variables

Catalog variable dependency on referenced fields (Simple)

https://www.youtube.com/watch?v=xZIMd0AurkQ

[Ankur Bawiskar]

@RadhikaG 

you can't dot walk a reference variable in reporting

You can use database view and add that extra table example: sys_user here and then add the respective columns

Databases view by request item and service catalog (variable) 

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! 🙏

[RadhikaG]

I have created the database view, but I am not able to get the catalog item variables and the reference field. which field should i suppose to select from the columns