Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1327
  • Last Modified:

Dynamic Report Width at RunTime based on Parameters

I have created an RDL file that displays dynamic columns based upon a multi-value parameter, hiding based is done by the Visibility property.  This is working as expected in the main report viewer screen, returning one page.  However when I select page layout I am receiving two additional pages.  I believe the addtional pages are coming from the overall report width, but I have to have the report that wide in the designer because of all of the dynamic columns.  Is there any way to modify this property through expression at runtime?  The width property of the section doesn't have an expression attached to it.  

Any ideas would be appreciated.  Thanks
0
DCG_Developer
Asked:
DCG_Developer
  • 2
1 Solution
 
Auric1983Commented:
DCG,

See if this from the MS KB helps but in without an expression box I'm not sure that you can define a dynamic width unfortunately.

http://msdn.microsoft.com/en-us/library/ms251701.aspx

0
 
DCG_DeveloperAuthor Commented:
It would appear that this is expected functionality ... Below is the Note from the MSDN article.  This is frustrating!!  I just checked BIDS 2008 and the same deal is there ... no expression on the page size or the interactive size properties.
Note
The width of a report can be greater than the width of the page. If a report that is wider than the specified page size is rendered by a rendering extension that supports page size, the resulting report may flow horizontally across multiple pages. If you have designed a report to be one page wide, but it renders across multiple pages, check that the width of the report is not larger than the page width.
Anybody have any ideas for a work around?
0
 
DCG_DeveloperAuthor Commented:
The final answer was that the functionality could not be accomplished and it seems to be an issue inside of SSRS.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now