Totext query

[munchen]

I am using crystal 8.5.

I simply want to remove the thousand separator from a group name field that appears in a formula.

Here’s what I currently have:

If X=Y then
‘***’ + (ToText(GroupName ({tblA.ID}),0,"")) + ‘***’
else
(ToText(GroupName ({tblA.ID}),0,""))

I keep getting the following error:

Too many arguments have been given to this function

Any ideas how I can remove the thousands separator from a group name field that appears in a formula?

 

[Madawc]

The code ought to work, it was fine for me on 8.5 with one of my fields.

Try using {tblA.ID} rather than the group field. They ought to be just the same value, but the syntax may be different

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10