Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Do business with those who do business with you
 
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
July

How Do I Only Display the Page Headings on the First Page in SQL Reporting Services 2008 R2?

During a recent SQL Reporting Services Consultancy session with one of my clients, they wanted to know how to only display the page headings on the first page of the report?

In SQL Reporting Services 2008 R2, when you add headers to the report it only adds Page Headers, and Page Footers to the report.

The only formatting option available is to display the header (and/or footer), on the First or Last Page.

Solution:
  1. Add the Page Header to the report

  2. Add the text boxes to make up the headings of the report

  3. Right click on the text box and select Text box properties

  4. Add the following code to the Visibility property

          =iif(Globals!PageNumber.Value = 1, False, True)

  5. Repeat steps 3 and 4 for all the text boxes in the section


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 *