Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

Thanks!

share|improve this question

closed as unclear what you're asking by Max Vernon, Paul White, Mark Storey-Smith, StanleyJohns, dezso Sep 27 '13 at 4:43

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
I had a comment, but then I re-read your title and replaced it with this. The title confuses me a bit: it says "non-grouped (SUM) column", but from the question I gather the sum in fact is for within the group, right? –  Jeroen Apr 22 '12 at 20:56