Concatination of String and Number in CR XI formulae 1

[paramsocool]

Hi

I am trying to combine a string and a number field together by using following syntax

table1.stringfield &"." & table2.number field

I have to put a "." between the combined fields. The problem i m getting into is that my original number field is some whole number like 13 etc. When I combine it with the string field I get two decimals as

stringfield.13.00

I tried removing the second decimal after 13 by using

table1.stringfield &"." & cstr(table2.number)etc but it is not helping. The result i expect is

stringfield.13

Please guide me

 

[dgillz]

Try this:

{Stringfield}&"."&totext({numberfield},0,"")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown