Sorting in SSRS Reports overriding Group sorting
- by Siva
I am new to SSRS (2005) and am creating my first report. I need to create a group-based running value but is sorted or some other field. For example, from the data below
|Employee| Day |Hours|Salary|
|E1      | 1.1 |  5  |  5   |
|E2      | 1.2 |  6  |  6   |
|E3      | 1.3 |  7  |  7   |
|E2      | 2.1 |  6  |  12  |
|E1      | 2.2 |  5  |  10  |
|E3      | 2.3 |  7  |  14  |
|E3      | 3.1 |  7  |  21  |
|E2      | 3.2 |  6  |  18  |
I am calculating the salary to be a running value on hours grouped by employee, which works fine. The problem is I want the report to be sorted on the Day column. If I use the Day as a sorting criteria in the employee group, the report is grouped on the employee, but within the group, the data is sorted on the Day column.
Is there a way to build the report and then finally sort the report on the day column ? Please let me know in case I am unclear.
Thanks a lot!
Siva.