Customizing Report Parameter control; handling "available values" collection.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Benjamin Chan - 30 May 2006 16:43 GMT

I have a report that I show a bill of material based on a selected
parent. I have about 17,000 parents to select from. When I use
"available values from query" the current behavior on the report is a
drop down box where I can choose between all 17,000 where at least for
large collections I'd prefer being able to start typing in and have the
control filter the query based on what's typed into the parameter. Is
there a way to do this?

Reply to this Message

Tim Dot NoSpam - 30 May 2006 18:19 GMT

Hi Benjamin.

I believe what you're looking for can be accomplished with a custom
parameter page. There is no way I know of with reporting services to
provide narrowing filter functionality out of the box.

>I have a report that I show a bill of material based on a selected parent.
>I have about 17,000 parents to select from. When I use "available values
>from query" the current behavior on the report is a drop down box where I
>can choose between all 17,000 where at least for large collections I'd
>prefer being able to start typing in and have the control filter the query
>based on what's typed into the parameter. Is there a way to do this?

Reply to this Message