SSRS Report Sorting with Grouping Issue

The SSRS tablix row group is CaseNo and Type, and sum(Net). I want to sort by Net descendent. I added the sorting in Tablix Properties - Sorting as Net desc (sum(Net) gets error). However, if the CaseNo is the same, the sorting was wrong. How can it be sorted only the Net desc regardless the CaseNo? Thanks.

what is the query behind this report look like?

The query has detail rows because the dataset is using for multiple tablixs.

leave SSRS to do what is does best, visualization. Do the sorting in the query itself could be my recommendation.

Thanks yosiasz,
It is resolved by adding the Net as the Parent Group.

1 Like