SQL Server Performance

Blank page on every other page!

Discussion in 'SQL Server Reporting Services' started by bubberz, Sep 13, 2005.

  1. bubberz New Member

    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.
  2. Madhivanan Moderator

    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
  3. bubberz New Member

    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.

  4. Akthar New Member

    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
  5. Madhivanan Moderator

    quote:Originally posted by bubberz

    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.


    So you got result?

    Madhivanan

    Failing to plan is Planning to fail
  6. bugster New Member

    I am glad I read this one...I forgot how to do this...

    thanks

    the
    Bugster
  7. bubberz New Member

    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!
  8. LairdSQL New Member

    Thanks Mahdivanan, this helped me too!

    Regards,



    LairdSQL
    "Nemo Me Impune Lacessit."
  9. Madhivanan Moderator

    <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
  10. smendira New Member

    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 | sumit.mendiratta@capgemini.com<br />Yahoo msg<img src='/community/emoticons/emotion-7.gif' alt=':s' />umitmendiratta30@yahoo.com<br />Join the Collaborative Business Experience<br />

Share This Page