Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
An investment in Knowledge pays the best interest
 
Franklin
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

13
May

How Do I Control the Headers and Footers based on Varying Record Report Items in SQL Reporting Services 2008

During a recent SQL Server Reporting Services 2008 report design project, the client wanted different headers and footers, based on different information on the page, of various lengths of data.

Because the report items, i.e. tablix and textboxes would contain varying number of records which could result in data being on one or more pages of the report, one could not simply use the Page Number function of SSRS 2008, to control the page header and footer text.

Solution

SQL Server Reporting Services 2008 has a feature called PageName, which allows report designers to name different report items, which can then be used to control the page breaks of the report.

To use the PageName function to control the Page Header/Footer text:
  1. Select the required Report Item on the canvas
  2. In the Properties Tab, enter the required PageName
  3. Add an Textbox Item to the Page Header section
  4. Enter a conditional expression, using the IIF function and the PageName function

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


MAKE A COMMENT

Name *

Email Address *

Comment *