Sorting by Summary in Group Footer

[davidanthonyb]

Hello,

I have a report I have grouped by one data column. In the Group Footer I am adding a text box sum(Have also tried using Calculated Columns). I would like to sort by this added summary, descending - to have the highest sum/grouping first and then so on. I do know how to apply sorting from within the data band > sorting, as well as in the interaction menu. However this appears to only sort the line items WITHIN the group.

To summarize, If I am grouping my report by one data field, how can I sort the separate groupings themselves BY the added summary text box?

For reference's sake I am using Reports.Web 2011.3.1200.

Thanks,
David

[Alex K.]

Hello,

Please try to use the SummarySortFirection, SummaryExpression, SummaryType properties for the GroupHeader component.

Thank you.

[davidanthonyb]

This worked wonderfully, thank you. I would not have thought to adjust anything in the Group Header since the sum object was in the Group Footer. Thanks so much, and cheers!

David

[Alex K.]

Hello David

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.