Foormula for PageNumber to fix printing problem
2

Question

Foormula for PageNumber to fix printing problem

DvDvDvDv (Programmer)

(OP)

30 May 01 10:59

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), ",") - 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 (Instructor) · Answer 1 · 2001-05-30 13:09:03

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 (Instructor) · Answer 2 · 2001-05-30 14:48:06

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 (Programmer) · Answer 3 · 2001-05-31 05:21:13

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

Come Join Us!

Posting Guidelines

Jobs

Foormula for PageNumber to fix printing problem
2