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 2008 display final total amount at end of report Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 12:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
found answer
Post #1578529
Posted Friday, June 6, 2014 3:59 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 10:16 PM
Points: 701, Visits: 4,486
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-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:19 PM
Points: 36,723, Visits: 31,172
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1578592
Posted Monday, June 9, 2014 8:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
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