Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 display final total amount at end of report Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 12:40 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 11, 2016 8:10 PM
Points: 532, Visits: 663
In an SSRS 2008 report I want to display a grand total on the last page of the report. This report has 3 existing groupings, but I want a final dollar amount total after the last summary line. I am hoping that this total can be in the 'main' matrix that is used in the report and not placed in a page footer.
Right now I have a second matrix in the main reporting area of the report that displays the report filters that the user selected to run the report. If I need to, I could place the report filters in the page footer of the report.

Would you show me the code and/or give me directions on how to place the final total amount after all the detail lines and summary lines have been displayed by the report?
Post #1578461
Posted Friday, June 6, 2014 3:19 PM This worked for the OP Answer marked as solution
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 11, 2016 8:10 PM
Points: 532, Visits: 663
found answer
Post #1578529
Posted Friday, June 6, 2014 3:59 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 1,987, Visits: 11,500
Which was what? use an aggregate function in a control at the bottom of the report?
Post #1578538
Posted Saturday, June 7, 2014 12:14 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:48 AM
Points: 41,203, Visits: 38,507
wendy elizabeth (6/6/2014)
found answer


Two way street, Wendy. What's the answer you found?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1578592
Posted Monday, June 9, 2014 8:41 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 11, 2016 8:10 PM
Points: 532, Visits: 663
create an outside group instead of an inside group of the last row in the matrix.
Post #1578852
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse