Trying to set Default Zoom to Page Width

Question

Post reply

Trying to set Default Zoom to Page Width

rachaeland

SSC Veteran

Points: 280
More actions
April 9, 2009 at 12:02 pm

#202908

We are wanting to set the default zoom to 'Page Width' when opening all our reports in Report Manager because we have several reports that have multiple sortable columns that print fine but when displayed at the default of 100% they chop off part of the line and aren't fixed until you set to Page Width or scroll to side and up which is extremely unfriendly for the end user and could result in them thinking there isn't a value for a column when there is. Can we do this or do you have other suggestions, if this isn't possible. Right now we are using Report Manager for the end-user but plan to go to Sharepoint Integrated mode so I don't know if we can handle this there. This is urgent because the user of the report won't use it as is. Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Wolfmeister SSCommitted Points: 1547 More actions · Answer 1

Hi,

I am having the same problem, has anyone come up with a solution for this yet? I am using SQL Server 2008 R2.

I tried adding the following code to the rsreportingserver.config file -

</DeviceInfo>

</Configuration>

</Extension>

however it makes no difference - the reports are still showing a default zoom of 100%.

I need to be able to see the entire report on the page - is there any way at all to do this, other than making everything on the report smaller?

Thanks

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 2

You should address this problem at the report definition level. I am not aware of any magic rsreportserver.config that could set the default zoom for you, and even if there was, trying to solve the problem that way would be a moving target. In other words no matter where you set the default zoom, if you can, it would be possible for somebody to come along and write a report that would still create the described formatting problem anyway. sure you could bump it to something way high that would be take in every conceivable situation but then everything would be too small.

Instead, my recommendation is to set the page setup under the reports properties to have a landscape orientation, and if the report requirements dictate a solution that make the report wider than 11 inches, I tell the report requestor that it wont print right if it gets any wider, or I attempt to wrap the columns to the next line.

I think setting a server-wide zoom setting would only cause you more formatting pain than help, and I actually hope such a setting doesn't exist...

Wolfmeister SSCommitted Points: 1547 More actions · Answer 3

Thanks getoffmyfoot, I agree with your solution. The only problem that I can see with this is how the reports will be displayed when using different screen resolutions, however I guess it's a case of educating the users on how to change the zoom level in the Report Manager to 'Page Width'!