2653383 - Activity Report is not Sorted Correctly After Export Excel

SAP Knowledge Base Article - Public

2653383 - Activity Report is not Sorted Correctly After Export Excel

Symptom

In the Export of the Activity Reprot, you notice that some columns ( Example: `Date`) is not beeing sorted as it is in Activity Report View in the Home Work Center.

Environment

SAP Business By Design

Reproducing the Issue

1.WoC: Home View: Self-Services.
2. Sub View: Self-Services Overview.
3. Click on link ‘Edit Time Sheet’.
4.View Activity Report.
5. Select the Project.
6. Click Go.
7. Click Export: ‘To Microsoft Excel’.
8. The Column ‘Date’ of the Excel Report is not sorted by correct date order.

Cause

Sort sequence applied in the UI is not considered in the exported spreadsheet. In excel export, data appears in the Excel in the same order in which the data is returned from the Backend.

Resolution

This is an Expected system behaviour.

Keywords

Activity Report, Excel Report, Project, Sorting, Sequence, Reihenfolge, Excel Bericht, Tätigkeitsmeldung , KBA , PT-EV-FO , Time Statement Form , Problem

Product

SAP Business ByDesign all versions