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.
.NET ProgrammingDB Reporting Tools

Avatar of undefined
Last Comment
Tone' Shelby
ASKER CERTIFIED SOLUTION
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
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.
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

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 ....
.NET Programming
.NET Programming

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo