Coriolan

I have a SQL Server Reporting Service report(server mode) that has only one string parameter (retrieved from a database) , thus the report parameter toolbar displays a dropdownlist.

Is there a way to control the width of that dropdownlist in SSRS2000 What about SSRS 2005 For example: make the dropdownlist fixed width Currently it is automatically sized to the longest string in the list so it is adding a horizontal scroll bar and my users dislike having to scroll to the right.

Many thanks in advance.



Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Brian Hartman - MSFT

This is the default browser behavior and the report viewer does not expose a way to override it. Even if you could change the width, you would just be clipping the string. So your simplest equivalent solution would be to trim the label in your valid values list. This would retain the parameter value for your report, but shorten the display string and resulting dropdown.



Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Ken Davis

Greetings Brian, I have the same situation. We are using SSRS 2005 and our parameter values sometimes exceed the default width of the parameter combo box control. I don't have the option of shortening the text. Is there any way to modify the width of the control

Best regards,

Ken Davis





Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Ken Davis

Let me clarify. My parameter in question is filtered based on the value of another parameter on the page. When the filtered parameter returns only one value and the length of the text string of the filtered parameter exceeds the width of the combo box, the drop list displays empty. Yet if more than one value is returned, and one of the values exceeds the width of the combo box, all values are displayed accurately and the user can scroll to the right to see all the text. I would consider this a bug that Microsoft needs to address. If I can widen the length of the combo box I would think it would at least give me a workaround.

Thanks to anyone who can assist in this matter.

Ken Davis





Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Brian Hartman - MSFT

Are you referring to the multivalue parameter input control If so, there is a known bug that when there is only one valid value and the value is long enough to cause a scrollbar, the scrollbar covers the value, making it virtually unselectable. You can workaround this by shortening the label for the parameter. You can also contact Microsoft support for the hotfix that addresses this issue.



Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Ken Davis

Thanks Brian, that is exactly what I am referring to. And I don't have the option of shortening the text, so I guess I'll contact Microsoft.

Regards,

Ken Davis





Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Tony Robyn

Hi, I have the same problem.

When I contacted Microsoft they told me I need the KB number of this issue.

Can anyone tell me what it is for this issue, because I can't seem to find it on the internet.

Thx

Tony





Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

ink24

Hi,

Has anyone located the hotfix for this problem as i am having trouble with the parameters.

Thanks in advance

Ian





Re: Visual Studio Report Controls Is it possible to control the width of the dropdownlist in the parameter toolbar?

Mike @ DanRic

I am using a multivalue parameter input control. My label value for the drop down list is frequently wider than the width of the display box. The display box allows scrolling from left to right, but I would like the width to be enough to negate the need to scroll from left to right. Any suggestions