In my report, I am displaying Position, Employee No, Hours worked, and Salary. Now, the user needs to show the Total hours and Salary by Position, Employee No. I can do this without any issues in the report. However, the user wants to export this information into Excel. To do this, I need to hide the details (which I can do). I then need to include the Position and Employee No in the summary row, so that the export to Excel will contain the position and employee no in each row. I am not sure how to do this in the report. Would like to know if anyone has any suggestions.
Sample Data (Position, Employee No, Hours worked, Salary)
Admin 1111 13 100
Admin 1111 05 56.75
Admin 2222 10 150
Admin 3333 54 550
Admin 3333 10 25
Clerk 4444 23 170
Clerk 4444 15 100
HR015 5555 70 1000
HR015 6666 13 67.95
HR015 6666 07 100
With the above data, I am looking for the following result
Admin 1111 18 156.75
Admin 2222 10 150
Admin 3333 64 575
Clerk 4444 38 270
HR015 5555 70 1000
HR015 6666 20 167.95
Any help is greatly appreciated.
------------------------------
Dn Pr
------------------------------