how to not repeat the title of the report in every page

sqlcurious
sqlcurious used Ask the Experts™
on
Hi experts, in my report, the title repeats in the second page and it doesnt have any results but just the title, this pattern happens for page2, page4, page 6 etc.
page 1 , 3, 5 etc has title and the results but page2,5,6 etc has only title, How should I avoid this in SSRS 2008?
thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Move the title to the report heading, not the page heading?
The problem is that your page is to wide. So it prints a blank page everyother page. Keep your margins and body smaller than 8' in profile and 11" in landscape.

Author

Commented:
Hi Twol And Planocz, thanks for the response but sorry, I donot understand either of your answer,
Planocz I tried changing the margin to 8' but it didnot work.
Thanks!
Commented:
When calculating page size, another thing to consider is the margin. You can use the following formula: Page width >=Body width + (2*Page margin).

Author

Commented:
thnks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial