question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

SSRS - Auto Layout

I have a report that is only really going to be used on screen and not on paper. What I'm looking for is a way to render the report based on the resolution. For example say I have two tablix next to each other, that will look fine on a wide monitor however if someone has a smaller resolution there will be a lot of scrolling so would prefer to have the right hand tablix under the first one. Is there any way of doing this?
ssrson screenrender
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I don't think that SSRS currently supports responsive design. Waiting for @Pavel Pawlowski to weigh in :)
0 Likes 0 ·

1 Answer

·
Mister Magoo avatar image
Mister Magoo answered
You might investigate this link, where there is an example of finding the screen width : [ http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8997758c-d431-4655-a442-fea51ababee7/can-reporting-services-in-a-web-browser-know-the-screenwindow-size][1] It says : > With a hint from SQL Server 2005 Reporting Services In Action, Lachev/Updegraff,I got as far as getting the screen size. Add references to System.Windows.Forms and System.Drawing. You do that in the "References" tab of the Report properties. The "..." button allows you to browse, so you get the syntax right. > > > Then code like this works (I tried it in the html renderer and designer preview only). > public function monitorwidth as integer dim scrnsize as System.Drawing.Size scrnsize = System.Windows.Forms.SystemInformation.PrimaryMonitorSize return scrnsize.width end function [1]: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8997758c-d431-4655-a442-fea51ababee7/can-reporting-services-in-a-web-browser-know-the-screenwindow-size
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.