DropDown width of database selection combo

In Query Analyzer the database dropdown combo is not wide enough to show
the full database name. We have a lot of database with similar starting
names and trying to decide which one to choose can be a matter of trial
and error.
Is there any add on perhaps that provides a wider dropdown to select the
database.
Has this been fixed in a more recent version?
Thanks,
Tom.
v.8.00.760
Have you tried Ctrl-U ?
Andrew J. Kelly SQL MVP
"Tom Corcoran" <tom.corcoran.nospam@.nospam.sportstg.com> wrote in message
news:%23%23MJ4UJqFHA.2696@.TK2MSFTNGP11.phx.gbl...
> In Query Analyzer the database dropdown combo is not wide enough to show
> the full database name. We have a lot of database with similar starting
> names and trying to decide which one to choose can be a matter of trial
> and error.
> Is there any add on perhaps that provides a wider dropdown to select the
> database.
> Has this been fixed in a more recent version?
> Thanks,
> Tom.
> v.8.00.760
|||Andrew J. Kelly wrote:
> Have you tried Ctrl-U ?
Wicked! Great shortcut.
Thanks, Tom.
sql

Dropdown width for Multi-select parameters

How can I control the width of the dropdown for multi-select
parameters? It seems to be showing up equal width dropdowns
irrespective of the size of the text. The problem crops up when the
length of the text for any option exceeds the default length, I get an
ugly horizontal scroll bar.
I can have a temporary fix by abbreviating the text content, but that
is not a long-term option.
N.On Feb 20, 1:18 pm, "Nidhee Pathak" <nid...@.gmail.com> wrote:
> How can I control the width of the dropdown for multi-select
> parameters? It seems to be showing up equal width dropdowns
> irrespective of the size of the text. The problem crops up when the
> length of the text for any option exceeds the default length, I get an
> ugly horizontal scroll bar.
> I can have a temporary fix by abbreviating the text content, but that
> is not a long-term option.
> N.
As far as I know, there's not a way to control the width of the drop-
down parameter. That said, it might be possible to modify the
underlying XML in the RDL file in some way that has not been readily
documented.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||What you can do is, you must be using a seperate query for displaying? , so
format / pad with spaces for display field from the sql query, so that the
display field can be in the required size, but the value is same.
Amarnath
"Nidhee Pathak" wrote:
> How can I control the width of the dropdown for multi-select
> parameters? It seems to be showing up equal width dropdowns
> irrespective of the size of the text. The problem crops up when the
> length of the text for any option exceeds the default length, I get an
> ugly horizontal scroll bar.
> I can have a temporary fix by abbreviating the text content, but that
> is not a long-term option.
> N.
>

Dropdown list width

Hi everybody,

I created a multivalue parameter in SSRS 2005 SP2, but the problem is that the width of the dropdown list is too small to fit my data (I'd like to avoid scrolling horizontally).

Is there any way to configure this?

Thanks in advance for your help.
Zoz

By converting the display parameter to a char value using convert(char(50),myvalue) as displayparam you should be able to make the field fixed width.

If you want to shrink the size of the box, you would need to limit the display output by using the substring function.

cheers,

Andrew

|||

Thanks for your answer Andrew.

Unfortunately, it doesn't work... I still need to scroll horizontally even when converting data to char...

May be there is some way to specify the width of the drop down list, but I have no idea where I could do that...

|||

there is a way to do this

-open up the dataset (assuming there is one) that returns values to your report params by clicking the ...

-now select the fields tab

-next edit the value column(by using an expression) for the field that is being displayed for your report parameter. you should be able to set a specified length of characters that you would like. this in turn will limit the width of the report parameter

sql