SAP Knowledge Base Article - Public

2358651 - How To - reorder columns in an Online Report Designer (ORD) list report component for export to output (CSV)

Symptom

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

 

Environment

  • SAP SuccessFactors HCM Core
  • Online Report Designer (ORD)
  • Analytics & Reporting
  • Advanced Reporting
  • Detailed Reporting
  • Live Data
  • EC Data

Reproducing the Issue

Try to reorder columns in the report query. When export report preview to CSV 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 (CSV).

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

KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors Workforce Analytics 1602 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608