Consider the following scenario. In Microsoft SQL Server 2008 Business Intelligence Development Studio, you create a report that contains page numbers. You export the report to Microsoft Office Excel format. Then, you open the Excel worksheet and then click Print Preview to preview the report. In this scenario, the page numbers may be hardcoded in the pages, and "Page 1 of 1" may be displayed for all the pages.
Note This problem does not occur in Microsoft SQL Server 2005.