SAP Knowledge Base Article - Public

2358651 - How To reorder columns in an Online Report Designer (ORD) / Canvas Report list report component

Symptom

How To - reorder columns in an Online Report Designer (ORD) report for export.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite > Online Report Designer
  • SAP SuccessFactors HCM Suite > Report Center

Reproducing the Issue

Try to reorder columns in the report query.
When export report preview to CSV or XLS the changes to column ordering are not applied.

Resolution

There are 3 ways to reorder columns in an Online Report Designer (ORD) report for export to output.

1. When the query is originally created from the list report component, column ordering changes will be effective. However, once saved, any subsequent changes will not be effective (please see below for further options).

2. Edit Formatting for the List Report Component > Drag and Drop columns to the required order > OK

KB - edit fomatting.png

 

3. Preview Report > View (in the header of the list report component).

This option when previewing the report (Runtime) allows a user to change the View of the report output by removing columns and also changing the column order. These runtime changes are not permanent, existing only for that report execution

Keywords

Report, Online, Designer, Canvas, Center, order, change, columns, export, csv, excel, xls, xlsx, not working , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HXM Suite all versions