Link to home
Start Free TrialLog in
Avatar of dspace
dspace

asked on

Report Footer in SSRS

I'm running SQL Server 2005 and using Visual Studio 2005 to create SQL Server Reporting Services reports.

Is there anyway to create a report footer (ala Crystal) - that is a section that would appear only at the end of the report?

Thanks for any help.
ASKER CERTIFIED SOLUTION
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dspace
dspace

ASKER

This is great!!!  Thanks very much to you and Kevin Goff.  That should be required reading for anyone trying to use SSRS.

I've accepted this as the solution but I do have two follow-on questions before editing my report.  

1. I have a Page Header and a Body.  I'm guessing that I have to incorporate the page header into the body in order to us a group - correct?

2. What would I group on to create a group that would encompass the entire report?

Thanks again.
Hi Thanks ...
Answers to;
1, Yes  ... 2. In order to group you use an element and group within the element such as a a table so if you want all elements to group together then you would place them within a table ...
Here is more information : Understanding Grouping  from MSDN that can explain in detail ..
http://msdn.microsoft.com/en-us/library/bb677373(SQL.100).aspx
Thanks Again ....