none
Increase the the size of SSRS Parameter Drop down list

    Question

  • I have a multi value paramater drop down. In which I am displaying both Customer ID + Customer name. However the drop down list does not expand (in width) to show the whole CustID + Name instead has scroll bars to scroll across which is quite inconvieneeint for the user.

    Thanks in advance@

    Tuesday, September 16, 2008 6:04 PM

Answers

  • I just want to point out that referencing the internal structures of the ReportViewer is not supported and therefore this type of workaround is very likely to break in the future.  We are aware of this problem and are working to address it in the next version of the ReportViewer control.

    Friday, November 21, 2008 10:02 PM
    Moderator

All replies

  •  SyMan wrote:

    I have a multi value paramater drop down. In which I am displaying both Customer ID + Customer name. However the drop down list does not expand (in width) to show the whole CustID + Name instead has scroll bars to scroll across

    Agreed.

    This is true for multi-value parameters. I have larger "Select one" parameters and smaller multi-value parameters not displaying the entire text.

    I think you should report this problem to Connect.microsoft.com.

    Tuesday, September 23, 2008 8:13 AM
    Moderator
  •  

    I discuss a method by which you may increase the size of this dropdown here.  The post addresses reports generated via the ReportViewer control, but I discuss how it may be applied to the Report Manager system in the comments section.

     

    Hope this helps!

     

    Brandon

    Friday, November 14, 2008 6:48 PM
  • I just want to point out that referencing the internal structures of the ReportViewer is not supported and therefore this type of workaround is very likely to break in the future.  We are aware of this problem and are working to address it in the next version of the ReportViewer control.

    Friday, November 21, 2008 10:02 PM
    Moderator
  • Although the proposed solution does (unfortunately) take advantage of the internal control hierarchy of the ReportViewer control, this appears to be the only such solution after close to four years of the problem persisting.

    Since, to my knowledge, the problem persists in SSRS 2008, the issue will likely continue well into the future.  Waiting a half-decade (and likely longer) for a solution seems well below optimal.  Taking advantage of internal structure, therefore, given the lack of alternatives, appears a reasonable remedy.

    Others may, obviously, come to a different conclusion; their sole remedy at this time is to continue waiting.

    Brandon
    Sunday, December 14, 2008 9:00 PM
  • Hi brian,
               Could you please tell us, was the issue of increasing the width of MULTI VALUE DROP DOWN LIST BOX is fixed or any alternative means to increase the width? Could you pls give your thoughts.
    I found few solutions:
    1. Embeeding the custom srcipt in CSS, for ASp.NET page. But for custom Reporting Service Page, how can we do it>

    -Prabhu
    Monday, October 12, 2009 4:34 AM
  •  

    Brian

     

    Is this problem fixed in 2008 ?.If  so which version

     

     

    Monday, November 22, 2010 8:47 PM
  •  

    Brian

     

    Is this problem fixed in 2008 ?.If  so which version

     

     


    This is still unanswered!

    This is very unprofessional from Microsoft.

    I wonder if anybody reads this.

    Monday, October 24, 2011 5:55 PM
  • I would also like to know the status of this.  Seems like such an obvious thing that users would want.  Hard to understand why it is ignored.  Sometimes parameter choices need to be long to be adequately descriptive.
    Friday, November 11, 2011 9:28 PM
  • When will this be available.  It has been over 3 years since this was supposed to be in the next version.
    Friday, January 27, 2012 10:11 PM
  • SQL 2012 also doesn't have the solution for this problem.....
    Wednesday, September 19, 2012 6:32 PM
  • figured I'd send my hacks along to you, but there's no way to message someone directly :/  The best I can do is simply reply with what made 2012 "suck less" for me.  ParentContainerControl was just used to limit the affect of this CSS to just the Report Viewer control within my application.  This includes my standard hacks + my IE7-specific hacks + my IE8,9,10-specific hacks...

    /* REPORT VIEWER CSS */
    .ParentContainerControl table { width:100% }
    .MyLayout { width: 100%; }
    .ParentContainerControl table tr[isparameterrow="true"] input[type="image"] { width:18px; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(2) { width:40%;  }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(5) { width:40%;  }

    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(2) input[type="text"] { width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(2) select { width:92%; display:block; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(2) textarea { width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(2) iframe { width:92%; }

    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(5) input[type="text"] { width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(5) select { width:92%; display:block; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(5) textarea { width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] td:nth-child(5) iframe { width:92%; }

    /* IE7 hacks */
    .ParentContainerControl table table { *width:auto; }
    .ParentContainerControl table tr[isparameterrow="true"] { *width: 100% }
    .ParentContainerControl table tr[isparameterrow="true"] td + td { *width: 40% }
    .ParentContainerControl table tr[isparameterrow="true"] td + td + td { *width: 10% }
    .ParentContainerControl table tr[isparameterrow="true"] input[type="text"] { *width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] select { *width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] textarea { *width:92%; }
    .ParentContainerControl table tr[isparameterrow="true"] iframe { *width:92%; }

    /* IE8,9,10 hacks */
    .ParentContainerControl table table { width:auto\0/IE8+9; }
    .ParentContainerControl table tr[isparameterrow="true"] { width: 100%\0/IE8+9 }
    .ParentContainerControl table tr[isparameterrow="true"] td + td { width: 40%\0/IE8+9 }
    .ParentContainerControl table tr[isparameterrow="true"] td + td + td { width: 10%\0/IE8+9 }
    .ParentContainerControl table tr[isparameterrow="true"] td + td + td + td + td { width: 40%\0/IE8+9 }
    .ParentContainerControl table tr[isparameterrow="true"] input[type="text"] { width:92%\0/IE8+9; }
    .ParentContainerControl table tr[isparameterrow="true"] select { width:92%\0/IE8+9; display:block\0/IE8+9; }
    .ParentContainerControl table tr[isparameterrow="true"] textarea { width:92%\0/IE8+9; }
    .ParentContainerControl table tr[isparameterrow="true"] iframe { width:92%\0/IE8+9; }



    - A Managed Coder

    Monday, November 26, 2012 8:55 PM