I dont think in SSRS its possible. Becouse the datasets are eveluated when you click on the view report button. So, the final selection will be applicable i.e. if you...

I am not sure about the first option. But we can definitely toggle the visibility of a column as we are doing it for the rows to achieve the drill-down...

yes, it does. Thats what I tried when the sheet renaming did not work. Did you change any setting to enable this feature. Even I downloaded the sample report that...

Even I thought so. It has groups and I have given page breaks after each group. While writing in the excel file it is also creating the sheets but the...

Oops.. I tried the following link to implement the same. But it did not work as expected.

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

You can format the reports in BIDS and specify the style in which you would like to see when you export the reprts. You will find the Format option in...

Thanks for the quick response.

Its really a nice artice, but I think can fail in the following scenario.

1)There are more than two columns

2)Atleast two records are there.

3)Alternately each column has null values and...