Displaying employee no without separator and decimals 1

[makk07]

Hi Everyone,

In my database the employee number is stored as follows:
8,367.00
29,785.00
140,742.00

And in the report I have a group based on formula to display employee name and employee number. My formula is as follows:

{@Full Name} & ' - ' & {table.EMPLOYEE NO}

and in the group tree you will see it as

john,smith - 140,742.00
but I want to display it as

john,smith - 140742, and I am using crystal XI

Please anybody suggest how to achieve that.

Thanks in advance
makk07

 

[lbass]

If employee number is a number field, then use:

{@Full Name} & ' - ' & totext({table.EMPLOYEE NO},0,"")

...where 0 is the number of decimals, and "" removes the thousands separator.

-LB