SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 How to hide/view a SSRS report parameter control d
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

6 Posts

Posted - 03/06/2014 :  04:36:32  Show Profile  Reply with Quote

I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection.

Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 & Parameter 5).
If user selects second value in first parameter I should show third parameter and hide remaining 3 parameters(Parameter 2,Parameter 4 & Parameter 5).
Similarly If user selects third value in first parameter I should show fourth and fifth parameter and hide remaining 2 parameters(Parameter 2 & Parameter 3).
There is no relationship between these parameters except user selection.

I can not see any Visible property for report parameters.
Any "builtin" support in SSRS for this scenario.

Appreciate your help.

James K
Flowing Fount of Yak Knowledge

3865 Posts

Posted - 03/06/2014 :  11:14:58  Show Profile  Reply with Quote
What you need to use is cascading parameters http://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx

Edited by - James K on 03/06/2014 11:15:27
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000