Solved

SSRS Report Header and Footer

Posted on 2009-05-11
4
701 Views
Last Modified: 2012-06-27
HI i am a newbie to SSRS, could anybodyplease tell me
what information do i have to include in the Report Header and Footer in general ?
for example if i am developing a  summary report which provides the total number of patients by sex and age band,
what do u think best fits in the header and footer metadata in the above example ?

Many thanks..
0
Comment
Question by:gvamsimba
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Auric1983
ID: 24357342
gvamsimba,

Typically, my report header will include a meaningful name for the report, in this case something along the lines of Patient Demographic Summary, the company logo, if the report has any parameters I also include them  here. For example if you have a date range you are reporting on I would say  something like

Patient Demographic Summary (larger text, bold perhaps)
--------------------------------------
Between StartDate and EndDate

As for the footer, I usually put the Page number, the Execution time (Globals!ExecutionTime)

In my line of business, a lot of our reports are Company Confidential, or Department Confidential, so I usually note that on the report header or footer as well.
0
 

Author Comment

by:gvamsimba
ID: 24357495
OK Thanks for the information Auric..shall i use a text box for header and footer ? and also can u please give me the expression for adding 'Between StartDate and EndDate ' Parameters in the  report header ?
0
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 total points
ID: 24357522

Yes I use textboxes.

The expression for the date parameters... i'm assuming you have parameters named @StartDate and @EndDate

="Between: " Parameters!StartDate.Value + " and " + Parameters!EndDate.Value


0
 

Author Closing Comment

by:gvamsimba
ID: 31580257
great...many thanks..
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question