1694126 - Project Task Column is Missing in The Exported Activity Report

Users have a requirement to view all the time recordings on the tasks of specific project. When users export those recordings into Excel, they may observe that the Project Task is missing in exported Excel.

SAP Business ByDesign

1. Go to the Home work center.
2. Select the Self-Services Overview view.
3. Select the Edit Time Sheet link.
4. Select the View Activity Report button.
5. In the popup screen, select a Project.
6. Select the Export button
7. Choose the To Microsoft Excel.

In the Excel, the Project Task column is missing.

The Project Task column is available in the Excel but as a hidden column so it is not shown explicitly.

Open the exported Excel:

1. Select both the columns (header level) six and seven using Ctrl key on the keyboard.
2. Right click on the header level (upon selection).
3. Select the Unhide option.

Now the Project Task column should appear.

Spreadsheet download, XLSX output, CSV output, Data field not displayed, Reveal fields in spreadsheet, Exported file display settings, Timesheet spreadsheet output, WBS element in download, Worklog spreadsheet download, Field visibility options, Assignment line in spreadsheet, Show all fields in XLSX, Layout settings spreadsheet , KBA , SRD-HR-TLM , Time and Labour Management , How To