Reports containing Variable columns cause slow-running queries and the report processing appears to be unresponsive - Known Error

Reports containing Variable columns cause slow-running queries and the report processing appears to be unresponsive Description A report containing variables in the columns generates a database query that can take several minutes to process, making the report look unresponsive.

Steps to Reproduce

Crete a report with the following values:

Report name : Variable Report Source type : Table Table : Requested Item [sc_req_item] On the Available list, select Variables [+] and click the plus sign.

Choose Service Category Request, and then Comments, and move them to the Selected list. Click Save .

When you run the report, try to export to CSV, PDF, Excel. The report will show the download dialog for a long time without progress. This process will be significantly slower than the same report without variables.

Workaround Remove the variables from the report.