asked
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.
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.
I would just create 2 reports and let the user decide what format they want.
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.
