In SSRS 2008 r2 standard edition using a subscription, you can deliever a report to a specific file directory location. If the report is in excel, will there be one excel workbook with lots of tabs or will there be lots of excel workbooks with one tab in each workbook?

Hi wendy, If you insert pagebreaks in the report, then each page will be put into one tab, otherwise, the whole report will be exported to one tab except the data rows reach the excel limitation. thanks, Jerry