How to add Report Footer in ssrs

Question

4.00/5 (2 votes)

See more:

, +

I know about the CrystalReports, but my current project use MS Reporting Services(SSRS).
I know only the basic of Reporting Services, and i dont know to add a Report footer(not a Page Footer) in SSRS. So anyone know about this please share with me.

Thank you,
Elk Cloner

Posted 23-Apr-12 23:46pm

Elk Cloner

Updated 24-Apr-12 0:54am

v2

Add a Solution

Comments

Mantu Singh 24-Apr-12 7:02am

I tried the same but can't find such option in SSRS project however posible in Crystalreports

2 solutions

Solution 1

In the body of the report. Add a table (if you haven't already) that contains the desired fields from the dataset containing your data.
You can then add a report footer easily to the report by right clicking in the leftmost heading table cell and selecting "Table Footer".

Posted 24-Apr-12 11:18am

ELiva

Comments

Elk Cloner 26-Apr-12 0:10am

I am using Visual Studio Version 2008 and .Net Frame work version 3.5. But i can't get this "Table Footer" option from the pop up that i got when i click on the left most heading cell. Is it any settings that i need to change for get this option. Please help me.

Thanks

Elk Cloner

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Elk Cloner · Accepted Answer · 2012-04-29T18:58:00

Hi,

By default, Report footer is not provided in SSRS.

So to implemnet this you need to take some workarounds

1) Create a page footer with a rectangle and set the Visibility expression to =Globals.PageNumber < Globals.TotalPages

2) Put item on report body section at the end and it will be displaed only once at last in report.

Hope this helps.