setting default page width - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

setting default page width

Author

Topic

stonebreaker
Yak Posting Veteran

92 Posts

Posted - 2009-10-23 : 09:30:21

I have a report that is very wide, 20.625 in. When I initially run the report, the report opens with the text very small, I guess so that it can fit the whole report on the web page. This makes the text too small to read, so I have to set the page width to 100%. Is there a property or parameter I can set so that it defaults to 100% page width when initially opened?

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-23 : 15:07:41

Regardless of how wide my reports are not one of them shrinks down. Are you talking about in the designer? I might guess you have print layout turned on... The icon the the right of the printer in report preview mode.

John
It's a small world (but I wouldn't want to paint it)

stonebreaker
Yak Posting Veteran

92 Posts

Posted - 2009-10-26 : 09:15:00

No, it's in the web browser. The zoom setting seems to be defaulted to "Whole Page". When I set it to 100%, the tables display at normal size. It displayed correctly before, I was wondering if I inadvertently set some display parameter, and if so, how to fix it.

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 09:43:03

Where is this "Zoom Setting"? Not one I am familiar with...

John
It's a small world (but I wouldn't want to paint it)

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 09:46:06

Ah, see it in report viewer... I will check my default server settings...

John
It's a small world (but I wouldn't want to paint it)

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 10:02:00

I would have thought that the default setting would be in the rsreportserver.config file:
http://msdn.microsoft.com/en-us/library/ms157273.aspx

Is this limited to just you or all users?

Found this on
http://prologika.com/CS/forums/t/914.aspx


<Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"
<Configuration>
<DeviceInfo>
<Zoom>100</Zoom>
</DeviceInfo>
</Configuration>
</Extension>

John
It's a small world (but I wouldn't want to paint it)

stonebreaker
Yak Posting Veteran

92 Posts

Posted - 2009-10-26 : 10:41:51

JCirocco,

turns out there is a setting in the XML code of the report, InteractiveWidth. Answer is to set

<InteractiveWidth>0in</InteractiveWidth>
<InteractiveHeight>0in</InteractiveHeight>

which lets the report spread out as wide and as tall as it needs. Your post on the <zoom> parameter is what got me looking at the code itself - I couldn't find that parameter on the design page.

Thanks for your help.

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-26 : 11:36:16

Glad I could help

John
It's a small world (but I wouldn't want to paint it)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources