How to get SSRS report fit to page (one page wide and multiple page long) while printing from report viewer control in web application?
Hi,
I am working with a report viewer control of webforms to display a server report. I have created a report which is having custom paper size(19inch wide and 10 inch in height) also
my other reports are like that only. I want this report to fit one page wide and multiple pages long when I print report. I am using report viewer control to diplay this report on web application. Can anybody tell me how to scale down the report size to suite
the paper size also does it require re-rendering of the report while printing? And if yes how to do this? Is there any way to extend the report viewer control of webforms for setting up custom printing options?
I am in a big trouble please help me out.
Regards,
Satish K.
March 10th, 2011 2:38am
Have you looked at Report Propertis under Layout tab? You can exchange values for Height and Width and see how was it goingBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2011 3:27am
Hi Uri,
Thanks for your quick reply. Actually my report has got large number of columns so I cant exchange the Height and Width of the report.
Any other solution?
Regards,
Satish
March 10th, 2011 3:58am
Hi Satish,
I’m afraid we can only set the page size when authoring the report. After deployed the report to the Report Server, the Page Size properties of the report cannot be changed.
Currently, one workaround is to design 2 editions for each report, one for viewing in the Report Viewer and the other for printing. For the printing one, we can set the font, controls
and page size smaller to suite the paper size.
We appreciate your understanding. If you have any more questions, please feel free to ask.
Thanks,
Tony ChainTony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 2:12am
Hi Tony,
Thanks a lot for your valuable reply.
As per the work around suggested by you, we need to create another copy of the report to suite the paper size.
But here in my scenario, a user is going to select the paper size as per the user location/preference. So when user clicks for report print is it possible to readjust the report
size as per the user selected paper size, proportions and page orientation?
Also in my report, the report columns are dynamic (conditional) as per the report parameter selections. I think this also needs to be considered while deciding the paper to print.
Secondly is it possible by any way to a user to set the print area of a report just like excel?
Regards,
Satish
March 11th, 2011 2:52am