SSRS Parameters - Autocomplete

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » SSRS Parameters - Autocomplete

SSRS Parameters - Autocomplete

Rate Topic

Display Mode

Topic Options

Author

Message

davdam8

Posted Tuesday, February 19, 2013 3:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 162, Visits: 597

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

Best Regards!

Post #1421510

sql_reporting

Posted Wednesday, February 20, 2013 7:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:39 PM
Points: 25, Visits: 131

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

davoscollective

Posted Sunday, February 24, 2013 8:01 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:54 PM
Points: 413, Visits: 701

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 »

Permissions