Solved

SSRS Report Header and Footer

Posted on 2009-05-11
4
705 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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