LTRIM and Report Source

Hi there,

I’ve upgraded to the latest version of COv4 and an exciting thing has started happening.

The following statement in the ‘Report Source’ for a report used to work prior to the application of the latest version:

LTRIM ( RTRIM ( per.firstname ) + ‘ ‘ + RTRIM ( per.lastname ) ) AS _payername

Now it crashes.

I’ve removed the LTRIM and associated parantheses and it works fine.

I appreciate that it’s not the end of the world (although I have to search through all the reports to find this type of statement) but have you any insight you could offer?

The build is 1068, the database is 1.067 and it’s .NET 4 Full Version.

Thanks,
Adminboy.