Solved

SSRS 2008 Toggle Parameters view

Posted on 2013-01-23
1
449 Views
Last Modified: 2013-01-23
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.
0
Comment
Question by:spoye
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 400 total points
ID: 38811345
Unfortunately you cannot affect on parameter visibility dynamically.

What you can do is add more logic to your queries.
You could add parameter stating 'Use Item or Location' (parameter sort)
You can also fill the @Item parameter list depending on this first parameter. Either with locations or items (if possible).

Then the main dataset:
if @Sort=1
SELECT * FROM #t
WHERE Item = @Item
ORDER BY Item
ELSE
SELECT * FROM #t
WHERE Location = @Item
ORDER BY Location
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question