<div>
<div class="content wysiwyg-content">
I have a report the passes in 2 parameters, endusers want to only view the parameter they wish to pass in. &nbsp; In my case we use Item or Location. &nbsp; Is it possible to have toggle the parameters visiablility? &nbsp; Case: if i want to Sort by Item i do not want to enable the location parameter.
</div>
</div>


I have a report the passes in 2 parameters, endusers want to only view the parameter they wish to pass in.   In my case we use Item or Location.   Is it possible to have toggle the parameters visiablility?   Case: if i want to Sort by Item i do not want to enable the location parameter.

SSRS 2008 Toggle Parameters view

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.