SQL Server Performance Forum – Threads Archive

Blank page on every other page!

When I Print Preview a report I get every other page with no data. I’ve only got one ListItem object on the page. If I export the report to .pdf, then the report is fine with no blank pages. I made sure the page width and height were fine to match with the margin sizes.

---

In Crystal Reports there is option "Suppress Blank Section"
See if you find the same in SSRS also Madhivanan Failing to plan is Planning to fail

---

Thanks Madhivanan! I wish it was like Crystal Reports. I had to take a little off the width of the object as well as the layout, and that did the trick.

---

i think you should cut off some width and it should be fine[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS

---

So you got result? Madhivanan Failing to plan is Planning to fail

---

I am glad I read this one…I forgot how to do this… thanks the
Bugster

---

Madhivana, Yes, taking some width off the object (I think it was a table) did the trick. Now I’m always on the safe side and make sure the margins are @ 1" left and right, and set the page property to just a tick under 6.5 inches. Thanks!

---

Thanks Mahdivanan, this helped me too! Regards, LairdSQL
"Nemo Me Impune Lacessit."

---

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LairdSQL</i><br /><br />Thanks Mahdivanan, this helped me too!<br /><br />Regards,<br /><br /><br /><br />LairdSQL<br />"Nemo Me Impune Lacessit."<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />You are welcome [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

---

No nothing depends upon setting the width.<br /><br /><br />Just make the width of the container(eg Rectangle) in which u have taken ur table<br />Set the Rectangle width equal to that of the reoprt(i.e there should be no space left between the rectangle’s<br />boundry and the report)<br />It should be done throughout the report.<br />Or else it will give u a page break.<br /><br />Try it . I am sure it will work.<br /><br /><br />Cheers<br /><br />Thanks & Regards<br />Sumit Mendiratta | Capgemini | Mumbai<br />Consultant,Custom Software Development<br />Office +91 22 5556 3323 | Mobile +91 9819249554 | www.capgemini.com<br />Fax +91 5642 1100 | [email protected]<br />Yahoo msg<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />[email protected]<br />Join the Collaborative Business Experience<br />

---

]]>