Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS 2008 Toggle Parameters view

Posted on 2013-01-23
1
Medium Priority
?
456 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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 …
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

688 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