Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS 2008 Toggle Parameters view

Posted on 2013-01-23
1
Medium Priority
?
458 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:steven
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 1200 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

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 …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Loops Section Overview

886 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