Answered by:

Fit to 1 page / Page width

Question

I have a report in SSRS 2005. This report is intended to be legal/landscape. The business user exports to excel and requires that the output when they print is automatically set to "Fit To Page Width" [without setting their printer's global properties in control panel]. How can I set the properties in the report such that it always fits [width-ways] to one page, no wonder how wide the report is? I dont care if the report spans vertically over 1 page. The question here concerns width re-sizing, following having exported to Excel.

Answers

This is something that is currently not supported by SSRS 2005 (or SSRS 2008). We are however considering this functionality for the next release after SSRS 2008 R2. What we are thinking about are 2 modes: FitToPage (your scenario) and FitToWidth.

* The report still will run over to the next page if I extend a field a longer amount. The report should resize the output in print preview such that the page always fits, no matter how big any [* and all *] columns are. Essentially it would be like automatic post-rendering/resizing, such that a table of any size fits widthways on any sheet of paper, whether it is legible or not.

* The issue that I am talking about is such that when the user exports to Excel and then [in excel] goes to print preview, the scaling automatically sets itself to "Fit to: 1 page(s) wide by (1) tall".

I hope I have clarified any ambiguity in my explanation of the issue.

This is still an issue that requires resolution and I would appreciate it if someone could help.

This is something that is currently not supported by SSRS 2005 (or SSRS 2008). We are however considering this functionality for the next release after SSRS 2008 R2. What we are thinking about are 2 modes: FitToPage (your scenario) and FitToWidth.

Your response above was in March 2011 ... Currently I am working on a new project Sept 2011 using "SSRS 2008 R2" and have the same problem is SSRS EXECL "FITTOPAGE" or "FITTOWIDTH" fixed yet ???? any ETA.