After upgrading our server from SQL 2008 to SQL 2008 R2 all of our reports have page totals now show the current information in the report viewer but show Page 1 of 0 when exported
to PDF or printed. The expressing we're using is in the footer and looks like
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
If I re-upload the report to the report server from the RDL this problem goes away. We have hundreds of reports and would rather not upload or change all of our reports.
Does anyone have any ideas on what would cause this or how we may be able to correct the issue in bulk?