Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A celebrity is a person who is known merely for being well known
 
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!!!!

25
February

How Do I Remove the Extra Pages in SQL Reporting Services 2008?

I have had a number of clients of the past few months all asking the same question, "How Do I Remove the Extra Pages in SQL Server Reporting Services 2008?"

This is an issue with all versions of SQL Server Reporting Services (SSRS), and is due to the ability to put any report item in any position on the canvas.


Solution

When designing reports within any version of SSRS, on must take two things into consideration:
  1. The size of the page set for the report
  2. The margins of the page
When a report is designed SSRS will allow any oject pllaced outside of the page and margin parameters, by compliing the report with extra pages, to stop this simply place the items within the confines of the page setup.

SSRS automatically takes the margins into consideration in the Design view, so place the items a 0.cm position on the canvas.


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 *