Concatenation formula displays # in decimal format

[jdemmi]

I have a formula similar to

GroupName ({TBL1.FIELD1}) + ' - ' + cstr(round(Count ({TBL2.FIELD1}, {TBL1.FIELD1})))

This displays
BLA BLA - 6.00

I want it to display

BLA BLA - 6
(no decimal or places after the decimal)

I have the # format in the report set to no decimal and I must cstr the count in order to use it in the concatenation formula.

What am I missing?

-- Jason
"It's Just Ones and Zeros

 

[WarrenRoss]

Try

GroupName ({TBL1.FIELD1}) + ' - ' + TOTEXT(round(Count ({TBL2.FIELD1}, {TBL1.FIELD1})),0)

PS: you only need to use CSTR or TOTEXT when concatenating using the "+" operator. If you use the "&" operator then the operands will be converted to strings implicitly.