Manage parameter dropdown list

I have an input parameter which has multi-value property checked. It has
dependence on the other input parameter and its value set is getting from
database. So, the number of row change when the other parameter changes. The
problem is the dropdown list sometime works fine, but the other time it
doesn't work as expected. For instance, there is case that there are only
two values in the list and the dropdown list gives me "Select All", first
item and a scroll bar. I need to drag the scroll bar to see the second item.
This is very annoying. The only good thing is that it did work consistently
in the sense of same value set always has same look in the dropdown list.
Is there a way to manage the displayable size of the dropdown list? How
about the input parameter text box length, is there anyway we can have any
control over this?Hi,
As you have mentioned that the "select ALL" comes as the first option and
you need to scroll down for the other two options. I think your query (in the
dataset) for this parameter is having spaces. Just have a look at the query
again and try to eliminate the null / space in your dataset.
Amarnath
"lu" wrote:
> I have an input parameter which has multi-value property checked. It has
> dependence on the other input parameter and its value set is getting from
> database. So, the number of row change when the other parameter changes. The
> problem is the dropdown list sometime works fine, but the other time it
> doesn't work as expected. For instance, there is case that there are only
> two values in the list and the dropdown list gives me "Select All", first
> item and a scroll bar. I need to drag the scroll bar to see the second item.
> This is very annoying. The only good thing is that it did work consistently
> in the sense of same value set always has same look in the dropdown list.
> Is there a way to manage the displayable size of the dropdown list? How
> about the input parameter text box length, is there anyway we can have any
> control over this?
>|||Sorry, if I didn't make it clear. No, what I said was the dropdown list
display first two items which are "Select All" and the first item in the
value set when I have only two items in the value set. Why I need to use
scroll bar to be able to see the second item. The dropdown list should just
have a window big enough to accomodate all three choice which are "Select
All", first item and second item.
"Amarnath" wrote:
> Hi,
> As you have mentioned that the "select ALL" comes as the first option and
> you need to scroll down for the other two options. I think your query (in the
> dataset) for this parameter is having spaces. Just have a look at the query
> again and try to eliminate the null / space in your dataset.
> Amarnath
> "lu" wrote:
> > I have an input parameter which has multi-value property checked. It has
> > dependence on the other input parameter and its value set is getting from
> > database. So, the number of row change when the other parameter changes. The
> > problem is the dropdown list sometime works fine, but the other time it
> > doesn't work as expected. For instance, there is case that there are only
> > two values in the list and the dropdown list gives me "Select All", first
> > item and a scroll bar. I need to drag the scroll bar to see the second item.
> > This is very annoying. The only good thing is that it did work consistently
> > in the sense of same value set always has same look in the dropdown list.
> > Is there a way to manage the displayable size of the dropdown list? How
> > about the input parameter text box length, is there anyway we can have any
> > control over this?
> >
> >sql