Hi Amit,

I too am also trying to figure out how to make tabbed reports in SSRS, but I'm using 2005, it's probably a lost cause. ANYWAY, I'm writing to tell you that even if you can't get the tabbed reports in ssrs to work properly, you can export to multiple tabs in excel. Simply have all of your report tables/matrices in the layout tab (its the layout tab in 2005, not sure about 2008) and insert page breaks before each table (start the page breaks on the second table in the layout, the first table will automatically export to the first tab in excel).

I know this doesnt get you where you need to be, but it could buy you some more time as a temporary solution.

Mike