Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs report display final total only on last part of report Expand / Collapse
Author
Message
Posted Monday, June 9, 2014 1:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:45 PM
Points: 375, Visits: 442

In an existing ssrs 2008 report, I want the final grand total to appear as the last amount displayed in the SSRS report.
In the 'main' matrix of the report, I have created an outside group row below the last line of the matrix.
The expresion for this statement looks the the following:
="Grand Total: $"+str(sum(cdec(Fields!TransactionAmount.Value),"datasetname")).

The total amount is correct, but this total amount line appears after every control break. Basically the amount appears every
time the control break changes by date, teacher, or student number.

The extra row I added does contain grouping references to date, teacher, and student number. Thus to solve my problem:

1. Can you tell me how to remove the grouping references to date, teacher, and student number so that the last row will be the only place the total amount will be displayed?
2. If the above is not an option, can you tell me how to add an extra row to the 'main' matrix so the report groupings do not appear on the final total line?
3. If the above 2 choices are not an option, would you tell me how to add the final total line in the final report footer and/or any place you believe the final total amount will appear only one time?
Post #1578954
Posted Monday, June 9, 2014 5:10 PM This worked for the OP Answer marked as solution
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:08 PM
Points: 179, Visits: 7,427
This is an ugly kludge that I'm sure there are better solutions than, but one inelegant way of achieving your #3 is to have a separate matrix/tablix directly below your regular results matrix. This separate matrix would only have the totals row, and will only appear at the end of the report. It ain't pretty, but I have seen it used to avoid the subtotals repetition you mention.

Doug
Post #1579011
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse