SAP Knowledge Base Article - Public

2288697 - Error in recruiting report when exported to Excel

Symptom

A recruiting report when generated and exported to excel results in the data in the columns been mixed up.

Environment

  • SAP Successfactors
  • Recruiting Reports

Reproducing the Issue

When trying to generate and export a report using the report option in the recruiting module it returns the following:

1

1.png

2. Generate Report

2.png 

3. Export report to excel

3.png

4. Returns data in Excel which is not sorted under columns.

4.png

Resolution

1. Please select all the text under Column A. Then choose Data tab and Text to Columns.

 5.png 

 

2. Followed by Delimited and Next

 6.png

 

3. Then tick the "Other" tick box and add the character "^" followed by Next.

7.png

 

4. Follwed by Next again and Finish.

 8.png

 

5. This will result in the reported information been sorted correctly under the various columns as shown below.

 9.png 

Keywords

excel, excel report. columns, Text to Columns , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem

Product

SAP SuccessFactors Recruiting all versions