Tuesday, March 27, 2012

excel export footer is a literal?

When a report is exported to Excel, the footer is set to a literal "page 1 of 1" even though it's specified as

="Page " + CStr(Globals!PageNumber) + " of " + CStr(Globals!TotalPages)

in the rldc report definition.

Hence, if you print from Excel every page has the 'page 1 of 1' footer. Not very useful.

Is there a way to either suppress the output of the footer (only when going to Excel cause you need it when exporting to PDF) -or- get it to generate the correct excel footer of 'page 1 of ?'?

Thanks,

Answer...

The above expression works but is wrong! The '&' should be used since this is VB syntax.

Changing the expression to

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

fixes the problem!

No comments:

Post a Comment