Foormula for PageNumber to fix printing problem 2

[DvDvDvDv]

Hi all.

I need to have my pages numbered. When I include the PageNumber in my report, it prints: 1,00 or 2,00 or 3,00 etc.. (note the , is printed as the . in english settings)

To avoid this problem I created a formula (maybe there is a better way to do that. If you know it, please tell me):

"Pg. " + ToText (PageNumber)[1 to (InStr (ToText (PageNumber), ",&quot - 1)]

Ok. now it prints 1 or 2 or 3 etc..

BUT

When I print from the web, it prints again 1,00 or 2,00 or 3,00

Why it happens ?

Do you know how to fix it ?

Please help me

 

[KeithBoyer]

Try to place the page number special field inside of a text object and try to format it there. Please let me know if this works or not.

kboyer@dmgrpt.com

 

[kenhamady]

What if you use "Format Field" to remove the decimal places of the original page number. This format setting should be stored with the report. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[DvDvDvDv]

Great !

Got the solution:

Instead of using a formula, using the text field and including the special field in it.

Thanks all for helping me.

Anyway, still can't find out why sometimes , using the formula, it happens and sometimes no.

Well, doesn't matter.

Dv