I am creating a report with 5 textboxes all inside a table cell connected to a dataset. Tb1 Would have a key value passed in and displays it to the user. Tb2 - tb5 are displayed depending on the value of tb1. I would like to know how could I configure the textbox display as follows: Value in tb1 is UK so tb2 and 3 are displayed. Value in tb1 is USA so tb4 and tb5 are displayed. Value in tb1 is Germany so tb2,3,4 and 5 are displayed? Thanks

Hi Pure ! You can set the Textbox properties -> Visibility option -> Show or hide based on Expression and set the following hidden expression; You may get the desired output using below expression ; =SWITCH ( ReportItems!Textbox1.Value = "UK", FALSE, ReportItems!Textbox1.Value = "USA", FALSE, TRUE ) Please let me know if this doesnt work for you. Hope I have answered you correctly. Thanks, Hasham Niaz

Hello Hasham Almost there :)....... Is there anyway to convert the above code so i can include it under the Code section of my report? I think having it under this section would make it easier to read and maintain? Ill try the above code and fiddle with it myself to see if i can get the results required. Thanks again

Hi Pure ! You might need to have a look at below article; http://praveenpoosapati.blogspot.com/2010/10/hideunhide-columns-in-ssrs-report-while.html You can create your function and specify the Hidden conditions there but you still need to call that function in the Visibility properties of your textbox. Please let me know if this doesnt work for you. Hope I have answered you correctly. Thanks, Hasham Niaz