Page in Excel File

Hi,

I have made some simple single table reports and using

="Page " & Globals.PageNumber & "/" & Globals.TotalPages

to display the page no against total pages

It works in the report previewer and pdf export, however, when I export it to excel file, all the reports display only Page 1/1.

Am I doing anything wrong or is there any bug

Anyone have solution/workaround and similar experience Please help.

Thanks.

MaxMan1

Hi Hobbs,

I put the page no. in the page header. I create a text item in the page header and set the value to

="Page " & Globals.PageNumber & "/" & Globals.TotalPages

For the same report, I can get Page 1/2 and Page 2/2 if I use report viewer to print. However, I get Page 1/1 only if I export it to Excel.

Hobbs, you said it works fine in header or detail part. How can you do that Is it the same with my case

Thanks.
Definite Reaction

Hi snoopyhobb,

Do you have any workaround to solve it Thanks.
cnuk
Hi

I faced the same problem too.Its a bug in 2005.I noticed so many bugs when exporting to excel in 2005.

Thanks

Hobbs
Devo
Hi William

If its displayed in the header or detail part then it works fine but if its in footer u will get like that only.How big is ur footer I mean how many report items are there

Thanks

Hobbs
Page in Excel File