|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Product/Service Type: Software Appliance
RSA Version/Condition: 7.0.2
|Issue||The display order of the columns marked under Reports > Chart > Columns tab changes on its own when saving the report. Changes are seen in the count of the column records when the display order changes. However, when they use the Preview button correct records are shown.|
The query below is used to create the report:
The correct order of the columns set by the user when creating/editing the report is as follows:
The output of the query when previewed:
After saving the report, the column order changes on its own as shown below:
Incorrect output of the chart after the disorder of the columns:
|Cause||The report query had quoted aliases with trailing space which was causing incorrect results and change in the order of the columns.|
|Resolution||Remove the extra spaces in the alias name or any other provided fields in the SQL query used in the report and save it.|
The extra blank space on the provided field names would be tricky to handle by the current code base, as it would require RSA Identity Governance & Lifecycle code to do query parsing and require a lot of efforts to be changes in the product logic.
Hence, the Report Query Developer should make sure that there are no extra spaces in any of the field names.