Solved

SSRS 2008 Toggle Parameters view

Posted on 2013-01-23
1
448 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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