Hi, I have a report with groups, I need individual groups on seprate tab/sheet when I export it in Excel. Your help is appricated. Thanks Pravin.

Pravin, This is possible only if you are using SQL Reporting Services 2008 R2. This is new feature introduced by microsoft. First of all you need to have a group with page break options as shown below. Once you are done with this then select Row Group(which is your group name). Select properties>> Set PageName property of your tablix memeber(your group) as shown below. Execute your report & export to excel you should have all tabs/sheets with group names there. Let me know if you have any queries. Thanks, Sandip Please "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thanks Sandip, this is quick turn around. Pravin