No, this is not a single big report that needs to go into different Excel tabs but different reports that need to go into separate tabs.

You can do this by creating one report that contains all of the reports you want to export as subreports. Since the only way to create multiple tabs in an Excel workbook is to set a page break at the start or end of a report item, put each subreport inside a Rectangle and set page breaks on the Rectangle. -Chris

Chris, What if I want to have a *single* report that exports to an excel workbook with several worksheets - example ...one report that runs for 10 clients and when exported to excel it should be a single workbook with each worksheet named with the client's name rather than Sheet 1 , Sheet 2 , Sheet 3 etc

You can have the report export with a page per client by having the contents of the body inside a list control groupped by client with the "page break at end" option checked. Unfortunately there is no way to specify that the customer names should be the sheet names.

Chirs, what if i want to give some nar for each tab. say Sheet1 would be EMP, Sheet2 Would be Dept and Sheet3 would be Prod etc. Thanks Sandeep Vaishya