Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS Parameters - Autocomplete Expand / Collapse
Posted Tuesday, February 19, 2013 3:25 AM


Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Hi geniuses!
It is possible to have the autocomplete features in a SSRS report parameter?
Thanks in advance!

Best Regards!
Post #1421510
Posted Wednesday, February 20, 2013 7:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:14 AM
Points: 25, Visits: 161
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.
Post #1422082
Posted Sunday, February 24, 2013 8:01 PM



Group: General Forum Members
Last Login: Thursday, December 18, 2014 4:24 AM
Points: 495, Visits: 895
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.
Post #1423459
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse