i have two tables in an rdl file - "table1" and "table2". these both tables are on the same body of the rdl file when i generate the report, the excel file has 'table1' as the first tab and 'table 2' as the second tab. In the front end there is a radio button for selection of table (either table1 or table2) what i want to do is - when the user selects the radiobutton for table1 - i want to display the excel with only one tab which is for table1 and when the user selects radio button for table 2 - i want to display the excel with only one tab which is for table2. can u tell me what filter or visiblity code i should use in the rdl table properties to show only the selected table. thanks justin

Hi, Suppose you have a parameter ShowTable. It has value 1 when you want to see Table 1 only and it has value 2 when you want to see Table 2 only. Then here is the expression for Visibility property of Table 1: (Parameters!ShowTable.Value = 2). For Visibility property of Table 2: (Parameters!ShowTable.Value = 1). Remember to mark as an answer if this post has helped you.