hi guys, i am basically exporting data from SSRS to excel. the format is such that i cld neither use a matrix nor a table.. so now when i export the data to excel from SSRS, i am getting the data in multiple sheets(sheet 1--sheet11) not sure if you call them sheets or workbooks.. but hope u guys understood my point. let me know if you need anything else

If you not using table, nor Matrix than what are you using, whats you layout. in general table's page break property splits exported data into different sheet. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi, Number of sheet formed depends on page breaks that you add in your report. Refer this link for reports rendering to Excel http://msdn.microsoft.com/en-us/library/ms159836(v=SQL.100).aspx