problem in rounding, concatenation

[dlkraft]

I am reporting from a query. I am trying to concatentate two numeric values into a formula field I am naming "account" and insert a 0 between the two values. Extra decimals are appearing.

The fields I am concatenating are "Gldept" and "Natcl."

I am trying to change them into text fields for the combination. Even using the following formula with round() I get extra decimals:

IF {Query.Glacct} = 0 and {Query.Natcl} < 1000 then ToText (round({Query.Gldept})) + ToText (round(0))+ ToText (round({Query.Natcl}))

Can you help in removing these dang decimals? Thanks!

Dave

 

[kenhamady]

Totext reformats the rounded numeric. Try:

.. then ToText ({Query.Gldept},0) + '0' +
ToText ({Query.Natcl},0)


For more format options lookup ToText in the CR Help Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal