Run Report to Excel - how to set Fit Sheet to One Page.
I have an Report Studio report that I want to Run and open in Excel and allow the client to Print without having to manipulate. On some reports I may want to Fit Sheet to one Page, others I might want to Fit all Columns on One page, etc. I want to be able to control the print settings of the worksheet. BTW - There might be multiple worksheets in each workbook (that is my next question). How can I control the Excel print settings?