Hi,I have a problem in SSRS 2005 for one of my report. Basically this report is a drill down report with around 3 grouping in one table and 6 grouping in another table. There are one parameter that set whether I want to show table1 or table2 that consist the drilldown. In the properties visibility->hidden of the table, I create expression =iif(parameters!view.value=1, False, True) to show only one of the selected table. Everyhting is ok with the report and other type of render, except for excel. Normally if I did not use the expression the export to excell, it will show the sub-total function of excell for all the drilldown in the report. But if the expression is use visbility->hidden, the sub-total function of excell is gone.Can anyone help will with this problem ? Is it a bug ? Thanks.Cogan

Hi Cogan,We can't reproduce the issue in our test environment based on your post. Please describe the issue in more details and make it clearer, especially the subtotal's calculations.thanks,Jerry

Hi Jerry,Thanks for your reply. First I have a report using the wizard to have a drilldown on that report. You know something that it shows the first level and then you press the + sign and you go down the next level until to the lowest level.After having this wizard, this is become the first table and I did not change any table properties yet, let say this is table1. Then I copy the existing table and paste it to create another table, let say this is table2 and I did not change any table properties to this table yet. When I run this, I got two table and when I export to excel, the excel show the subtotal on the left side of column A. With this user can drill down also in excel whatever they want. So, there is no problem in this stage. Now, I want the user the select to show only one table, either table1 or table2 depending on the filter the user want to see. Let say, I create new parameter to show table1 or table2 and then when user select table1 it is only showing table1 while hiding another table which is table2. To achieve this I create new parameter View which consist of integer value 1 and 2. So when user select option 1, it shows only table1 and hiding table2. Then I modify the table properties for table1 and table2 in the Visibility and the Hidden to create expression. The default value is always false and I change it to expression =iif(parameters!view.value=1, False, True). So I would like the RS to show only table1 if user select 1 otherwise hide it.Everything is ok with the report it works fine. If user select option 1 they got the table1 automatically and hide table2. But my big problem is, when I export to excel, the functionality of subtotal is gone in excel. There are no subtotal structure in left side before column A, it is gone. Funny thing about this error is if I use expression whatever it is the export to excel with subtotal is gone, but If I use the standard one with default value 'false' it is ok. I hope this is clear and I really appreciate your help. Thanks.Cogan

Hi Cogan I also got this issue too. And i have no idea to solve. Do you have any solution yet ? Please let me know. regards. Thanapat