February 19, 2013 at 3:25 am
Hi geniuses!
It is possible to have the autocomplete features in a SSRS report parameter?
Thanks in advance!
Best Regards!
February 20, 2013 at 7:30 am
what is meant by auto complete is it you need default values to all the parameters. Than in that case you can set up default values to all the parameters.
February 24, 2013 at 8:01 pm
Not directly in SSRS.
If you create your own ASP.NET page with the report control you can use a text box with AJAX or similar technology to achieve this effect.
By itself, SSRS won't do it, and it's not really meant to be a search engine.
The best way to help your users is to use the "available values" of a parameter. You can provide a dataset to the available values which will populate the parameter drop-down list. It's best to keep these lists short for usability reasons.
Another option is that you take a free-text parameter and work it into a query somewhat like this
where databasecolumn like '%' + parameter + '%'
But I don't recommend that last option. It's too open ended and while it looks helpful to your users it's really not. Providing them a drop-down list is far better.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply