Foormula for PageNumber to fix printing problem 2

DvDvDvDv · May 30, 2001

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 · May 30, 2001

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 · May 30, 2001

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 · May 31, 2001

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Foormula for PageNumber to fix printing problem 2

DvDvDvDv

Programmer

KeithBoyer

Instructor

kenhamady

Instructor

DvDvDvDv

Programmer

Similar threads

Part and Inventory Search

Sponsor