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:

[sergiu_panaite]

Hi Shane,

Can you give an example of what you mean by variable data?

A database view is just a predefined query that is run when called, so there are no fields stored like in a table, and this is why I believe you cannot choose the variable data.

Regards,

Sergiu

[shane_davis]

Sergiu,

        When I create the report off of the database view which combines the Approval and Catalog Task tables, I add catalog variables in the selected box within the report.   This is, of course, so the report will show the data entered into the variable fields by the associate.   For example, in this case, when an associate completes the Wire Request catalog item form, I want to show the data they entered on the report.

      I have opened a HI ticket as I have found where others on the Community have the same issue.

https://community.servicenow.com/message/806822#806822

https://community.servicenow.com/message/801618#801618

Thank you,

Shane

[gyedwab]

Hi Shane,

What's the report you're trying to run?

[shane_davis]

Guy - The report is the second screenshot I included in the original post.   From the Available box, I expandRequest Item, then expand Variables and add the variables to the Selected box for my Wire Request catalog item.   However, when I run the report, the variable columns do not show.   When I save the report, the variable fields in the Selected box go out of Selected.   Thank you.