SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Parameters - Autocomplete


SSRS Parameters - Autocomplete

Author
Message
davdam8
davdam8
SSC Veteran
SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)SSC Veteran (294 reputation)

Group: General Forum Members
Points: 294 Visits: 668
Hi geniuses!
It is possible to have the autocomplete features in a SSRS report parameter?
Thanks in advance!

Best Regards!
sql_reporting
sql_reporting
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 169
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.
davoscollective
davoscollective
SSC Eights!
SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)SSC Eights! (919 reputation)

Group: General Forum Members
Points: 919 Visits: 1004
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search