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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.




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.


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