Reporting Service - Group Page Break Problem while exporting to Excel

  • Hi,

    I have added one page break in the report and specified the Page Break at Start property to true. When I export this to PDF it was initially adding a blank page into pdf but after setting the table height same as the body height it worked. Now when I export it to Excel it is adding blank sheet as sheet1 and shows data in sheet2. Please suggest.

    Thanks in advance !

    Best Regards,

    Santosh

  • I'm guessing that the pdf is throwing out the initial page break while excel is keeping it. Try changing the Page break at start to a page break at end to see if the results are better.

  • Give the page break at the end for the table. I think it should work...

  • Thank you for your reply.

    Page break at end is having some issues like it shifts Grand Totals to new page, if you please know any way by which last page break can be avoided then it will be a great help.

    Thank you,

    Best Regards,

    Santosh Pawar

  • Do you have a body wider than the page size?

  • Thank you for your reply.

    Body is little less than the page size. Page size is 11" out of which .5" is used for margins and body is set to 10.5 "

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply