Exporting a report that includes many variables to Excel causes SQL Exception "Unknown column 'sc_item_option.value' in 'field list'".
Steps to Reproduce
Navigate to Reports > Create New.
Select the Data table "Requested Item [sc_req_item]".
Customize the columns by selecting Variables in the Columns Available.
Click the + sign that appears above the < and > arrows.
In the Catalog Items window, search for and select 'DG - Data Quality Issue Form'.
Select and add all the variables for DG - Data Quality Issue Form (approximately 75 variables).
Add a condition so fewer records are retrieved, for example, opened by 'Guest'.
Run the report.
The report runs successfully and the data is displayed correctly on the UI.
Right-click on the header and select Export to Excel.
The resulting Excel export contains only the headers and no data, and the following error is seen in the logs:
"Syntax Error or Access Rule Violation detected by database (Unknown column 'sc_item_option.value' in 'field list')".
Create multiple reports rather than a single report so that fewer variables need to be exported.
Related Problem: PRB675410