Report using database view not saving Variables

[shane_davis]

My goal is to create a report off of the database view below which will show approver, requested item, and variable data.

The only issue is that, when I save the report, all of the variable selected fields go away from the report (removed automatically from the selected box).   The selected fields in the screenshot save; any variables I add in addition to these selected fields are lost.

Database View:

Report:

[gyedwab]

I'm not sure what the issue with ServiceNow's reporting is (it seems like variable reporting is still hit and miss). I was able to replicate your report with Explore Analytics, without requiring the database view at all:

Approval to Catalog Task

The report can be live, and embedded into your ServiceNow dashboard, all the links go to the appropriate record.

[shane_davis]

Guy,

      I am not familiar with Explore Analytics, but your report is exactly what I'm looking for.   ServiceNow support provided an update last night that they were able to reproduce the issue in their OOB instance and it is likely a Problem.   They are reviewing further.   Can you provide information on where I can learn about Explore Analytics?   Thank you!

Shane

[gyedwab · Accepted solution]

Hi Shane,

Sure thing -- there's videos available on this YouTube channel, and technical documentation on this wiki. If you want to try it out, you can register for a free trial here. If you need anything else, feel free to message me and I'll help you out.

[shane_davis]

Thank you!   I will mark your last answer as the correct answer.   I appreciate the help.