Export print formatting from SSRS to Excel?
Hello, Is there a way to export page settings in my SSRS reports to excel? My customers would like to be able to print my exported report on a 11 x 17 sheet of paper in landscape orientation. They would also like it scaled to fit one page. When I export, my excel file automatically goes back to portrait orientation on a standard sized peice of paper with no scaling. Any help would be greatly appreciated!
June 15th, 2012 12:57pm

This needs to be on the SSRS forum. But to answer your question, No. The export to excel is basically a data dump with a little bit of formatting to make it look like the report. But the printing settings are not something exported from SSRS. PDF is better for printing.Excel is good for manipulating the data after exporting the report. Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2012 2:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics