SSRS Export to Excel not fitting on one page.

  • Is there a way to setup an SSRS format export to excel so that it will automatically fit to one page? Googling, most of the sites I browse say this is not an available option. Just wondering if anyone knew of any kind of work-around?

  • Hi, the only work around I can think of is to make sure that the report properties layout is set to the portrait (w 8.5in x h 11.27in) or landscape (w 11.27in x h 8.5in) size that you require. Then check the size of your table by selecting the table and looking at the size of the table in properties. It is not ideal as you may have to reduce the font size and the column width of some of the fields. You may also want to switch the can grow properties of some of the fields. This does work but is essentially a work around.

Viewing 2 posts - 1 through 1 (of 1 total)

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