Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Report Header and Footer

Posted on 2009-05-11
4
Medium Priority
?
710 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

618 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