Crystal report error

[rjoubert]

Using CR 2008. We have several reports that use a TOTEXT function wrapped around a varchar field returned from our DB. In some of the reports, this TOTEXT formula is using "#" as the 2nd parameter, and it seems to be causing an error (TOO MANY ARGUMENTS HAVE BEEN GIVEN TO THIS FUNCTION). I'm just wondering if this is due to our recent upgrade of Crystal Reports to 2008. Perhaps this worked in a previous version of Crystal, but is now invalid in Crystal Reports 2008.

 

[rjoubert]

The TOTEXT(..., "#") function was added to these reports to handle when that field was concatenated with other string values. But since the field in question is a varchar field, do we really need the TOTEXT function?

 

[hilfy]

No, you shouldn't need ToText if the fields are strings.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[rjoubert]

Thank you. I guess I just needed someone to verify that for me.