I have a SSRS Report that contains 3 columns: Asset, Project Type and Total Hours. Report is grouped by first level grouping on asset and second level on Project Type. For example, clicking on Asset "ABC" will expand Project Type as "Type1", "Type2" & "Type3" etc.
Now each Project Type has hours such as Type1, Type2 & Type 3 in previous example have respectively as 10,15 & 40 hours. These hours are total in report which is 65 as per previous example.
ASSET PROJECT TYPE HOURS
ABC TOTAL 65
DEF TOTAL 42.5
XYZ TOTAL 108.75
My Question: How can I sort the report in descending order by Hours, keeping the report structure intact?
Let me know for more information.