﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Reporting Services / Reporting Services  / SSRS Parameters - Autocomplete / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Wed, 22 May 2013 19:39:46 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: SSRS Parameters - Autocomplete</title><link>http://www.sqlservercentral.com/Forums/Topic1421510-150-1.aspx</link><description>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[code="sql"]where databasecolumn like '%' + parameter + '%'[/code]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.</description><pubDate>Sun, 24 Feb 2013 20:01:00 GMT</pubDate><dc:creator>davoscollective</dc:creator></item><item><title>RE: SSRS Parameters - Autocomplete</title><link>http://www.sqlservercentral.com/Forums/Topic1421510-150-1.aspx</link><description>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.</description><pubDate>Wed, 20 Feb 2013 07:30:40 GMT</pubDate><dc:creator>sql_reporting</dc:creator></item><item><title>SSRS Parameters - Autocomplete</title><link>http://www.sqlservercentral.com/Forums/Topic1421510-150-1.aspx</link><description>Hi geniuses!It is possible to have the autocomplete features in a SSRS report parameter?Thanks in advance!Best Regards!</description><pubDate>Tue, 19 Feb 2013 03:25:41 GMT</pubDate><dc:creator>davdam8</dc:creator></item></channel></rss>