Searchable drop-down list

[bustercoder]

Hello,

I have a drop-down list being used to pull in input parameter for the report, but the list is VERY long, into the hundreds of records. Is there a way in SRS 2005 to make the list searchable, so the user can drill down to get closer to what they want by typing in the first two or three characters of the value?

Thanks,
Buster

 

[FlaBusInt]

One thought off the top of my head:

Set up a pair of cascading parameters. The first parameter would allow the user to type three characters. The second parameter would be the query that generates your list, but it would now accept the first parameter and include a WHERE clause like:

WHERE ListValue like @Param1+'%'