Currently, if I simply report on the sc_req_item table I am able to CHOOSE COLUMN select into Variables[+], select a catalog item and then choose from one of the field variables and add it to the column of the report.
Currently, I need to report on both the sc_req_item table and sys_approval_approver table to see the current approver for the ritm in the report. I have created a database view table for both sc_req_item and sys_approval_approver, however 'Variables[+]' option is no longer available in the 'choose column' button when reporting.
Following the following KB, I was able to report on the variables and values (last image of link).
Is there a way I could add a variable to the column of a report on a Database View as well? Any suggestions would be appreciated.
