Formatting Formulas

[MattN]

I am passing values to formulas in CR 8.0 pro through Vis Basic Code

ie.
Report1.Formulas(1) = "ADSNum = " & rstHEADER!ADSNum

rstHeader is a Numeric field containing the Value 10010.

When the report prints the field it prints 10,110.00

Is there a way I can format the formula so it prints correctly.

Kind Regards

MattN

 

[kenhamady]

If the report sees this field as a numeric, you can use the tool bar buttons in Crsytal to take off the decimals and the comma. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com