Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS 2008 - how to sort by Max(Total) in a group header

Status
Not open for further replies.
eo

eo

MIS
Apr 3, 2003
809
I have a report with two row groupings:
Group1 - StatusGroup,
Child Group(2) - ApplicationID

In the details section is amongst other fields a value (LoanRequested). It is aggregated at the Group2 group level as Max(LoanRequested). Is ut possible to change the order in which Group2 is displayed under Group1, so that it looks something like this:

StatusGroup - ABC
ApplicationID - B1002; Max(LoanRequested) - £2000.00
Detail - 1
Detail - 2
...Detail - n
ApplicationID - A1111; Max(LoanRequested) - £1600.00
Detail - 1
Detail - 2
...Detail - n
ApplicationID - L0002; Max(LoanRequested) - £1000.00
Detail - 1
Detail - 2
...Detail - n

Can anyone help, the grouping in SSRS 2008 is a bit of a dark art

EO
Hertfordshire, England
 
Status
Not open for further replies.

Similar threads

dawnanne
  • Question
Loop through rows in an SSRS table
Replies
0
Views
88
dawnanne
dawnanne
how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
783
PeterDimitrov
PeterDimitrov
tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
662
tarikqazza
tarikqazza
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
708
Tom_2023
Tom_2023
Quotheraven
  • Locked
  • Question
SSRS Expression for certification updates
Replies
0
Views
655
Quotheraven
Quotheraven

Part and Inventory Search

Sponsor

Back
Top