Failure to export built-in Globals to Excel
I've written a number of reports for my client using SQL Report Builder 3.0 on SQL Server 2008 R2. Everything is fine apart from one anomaly. Every report contains a text box in the footer with the following expressions: ="Page " & Globals!PageNumber & " of " & Globals!TotalPages ="Generated by " & User!UserID & " at " & Format(Globals!ExecutionTime, "dd MMM yyy HH:mm") When running the report, this text box renders as (for example): Page 1 of 3 Generated by DOMAIN\ThisUser at 03 Aug 2012 11:11 When the report is exported to PDF, this text is rendered exactly as it is on the report. However, when it's exported to Excel, ONLY the first expression is exported. The "Generated by xxxxx" expression does not appear. My client would like this expression included. Does anyone have any ideas? Many thanks Edward
August 4th, 2012 6:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics