x

dynamic page sizes in reporting services

I want to develop an SSRS report that, based on a parameter, will print conditionally to an A3 sheet or an A4 sheet. In other words if parameter value A is selected, set the report's PageSize Width property to 42cm and PageSize Height property to 29.7cm. If the parameter value B is selected, set the report's PageSize Width property to 29.7cm and PageSize Height property to 21cm.

There's no option to use an expression for these properties.
more ▼

asked Jan 04, 2012 at 05:31 PM in Default

GPO gravatar image

GPO
2k 33 37 41

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
Hmm..Nice one. But could you please specify why you need that? Since not sure if this is correct understanding but increasing the page height could be taken as increasing the number of records per page? And for expanding the width there could be a hidden/suppressed dummy field with expand property set to TRUE. When you need to expand, that dummy field could be filled with some data. I have not tested it due to time constraints, but seems like worth trying it if this is what originally required.
more ▼

answered Jan 04, 2012 at 11:31 PM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

I would just create 2 reports and let the user decide what format they want.
Jan 05, 2012 at 12:34 AM Scot Hauder
At the risk of oversimplifying it, the report is basically a couple of matrices, each containing gauges and charts. You can view it three ways depending on which parameter you choose. Option 1 is a filtered subset of option 2, option 2 is a filtered subset of option 3. Each option is a known size (a fixed number of matrix rows and columns) that won't vary. Options 2 and 3 fit nicely onto A3 (the customer requested A3 originally). Options 1 fits nicely onto A4 (the customer later requested the cut-down A4 option as well). I was hoping to avoid creating more reports than I had to, because we've already got quite a job ahead of us consolidating huge numbers of reports that are fairly similar. It is a valid complaint from our users that they can't see the forest for the trees when looking for a report on a given topic.
Jan 05, 2012 at 01:30 AM GPO
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x546
x7

asked: Jan 04, 2012 at 05:31 PM

Seen: 1769 times

Last Updated: Jan 04, 2012 at 05:31 PM