Page 1 of 1

Sorting by Summary in Group Footer

Posted: Mon Jan 30, 2017 7:24 pm
by 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

Re: Sorting by Summary in Group Footer

Posted: Tue Jan 31, 2017 9:48 pm
by Alex K.
Hello,

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

Thank you.

Re: Sorting by Summary in Group Footer

Posted: Wed Feb 01, 2017 12:01 am
by 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

Re: Sorting by Summary in Group Footer

Posted: Wed Feb 01, 2017 8:54 pm
by Alex K.
Hello David

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

Thank you.