Hi all, How to Visibe/Hidden one Parameter from Selecting Another one Parameter from Dropdownlist as per condition ? Example suppose Alluser Selected from dropdownlist not required to show the Textbox to enter the numbers of Employee but if User Select UserNo from dropdown list then he should give the pin number inthe corresponding textbox which is hidden . How to achieve this ? Abhay Sawant

Have you tried expression to vis/hide in textbox??Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I am using Sql2008 where I did not find any expression to vis\hid for Parameter. Abhay Sawant

Abhay Sawant I meant not for parameters , just hide text box, is that what you wanted?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi SSRS in BIDS and in report manager does not support dynamically hiding the parameter. The possible workarounds you may follow are 1. Instead of a drop down and then a texbox, use a dropdown with multi select on. (While creating the parameter, set the 'allow multiple values' check on). Multi select automatically adds one item on top to allow all item selection. 2. Develop your UI in a windows or web application and call the report in the server using server report or URL access. Hope this helps. Please feel free to discuss for any further questions.Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi Bilal, As per my requirement on this report is created by SSRS 2008 and I have a requirement like 1. First User should select parameter as a dropdown Options from Five list Like(All,EC,LPD,PD and Volume). 2. Condition is when user select All there should be no condition further and if user select except All from list he should enter the amont of percentage in two text boxes which further goes to query. Thas why I did not understand what u r asking for textbox which is here Parameter. Thanking you for corporation. Abhay... Abhay Sawant

Hi uri_dimant, I am working on SSRS 2008 and I am in the section where Parameter is added and then only Textbox or Table will use to show the Data. My question is how to get the parameter as per condition like from a condition of Dropdown i want to show or hid a textbox parameter. Thanks Abhay Sawant

Hi Abhay Sawant, As Bilal Hani posted, the visibility of the parameter can only be specified in designing. By default, if we don’t input the second parameter, the report cannot be viewed. So, please enable the Allow null value of in Parameter Properties of the second parameter. Then, users cannot view the report without specify the second parameter when the first parameter is specified to “ALL”. However, if users select other values in the first parameter but not specify the second parameter to view the report, we need to hide all controls in the report except one additional textbox for prompt. We appreciate your understanding. If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help