We have a number of wide reports which our customers wish to have exported to PDF fitting the width down to fit on a single page. These reports exceed even a US legal page in landscape orientation. It is understood that if the report is scaled to fit to page it will be unreadably without zoom.
Is there a way to do this? I understand that ideally the report's dimensions would be set to the dimensions of the target page but given the amount of data the report presents this is not a realistic option for us.
We are using SQL Server 2012.