June 9, 2014 at 1:36 pm
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?
June 9, 2014 at 5:11 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply