To generate multiple sheets in Excel you need to use a Report Book
. Each report in a report book will generate an extra worksheet in the Excel file.
However, note that the Report Book is not yet supported in Report Server
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal
and vote to affect the priority of the items