Solved

Dynamic Report Width at RunTime based on Parameters

Posted on 2009-07-02
3
1,138 Views
Last Modified: 2012-05-07
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
Comment
Question by:DCG_Developer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 total points
ID: 24762342
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
 

Author Comment

by:DCG_Developer
ID: 24762693
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
 

Author Closing Comment

by:DCG_Developer
ID: 31599130
The final answer was that the functionality could not be accomplished and it seems to be an issue inside of SSRS.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
bank transaction downloader ? 1 103
exporting a ssrs report to word 2 64
Tracking a Database Lock - SQL 2014 10 50
What is the best way to use power bi and ssrs 3 50
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question