I'm having trouble using .selectionformula and .sortfields properties
in my VB application. I'm reporting on a DB2 ODBC database, and have
something like:

rptMISReports.SelectionFormula = "{W03U999S.UNITCD} = 'EPP'"

This gives error 20515 - the field name is not known. UNITCD is
definitely a field on the table W03U999s however. I've double check the
formula with a message box and it appears fine, and it also works no
problem when input directly to the Crystal designer.

Any suggestions would be much appreciated. I've tried using different
brackets, moving them around, etc but without any luck.

Sent via Deja.com http://www.*-*-*.com/
Before you buy.