cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to parse SQL Expression Field

Former Member
0 Kudos

Hi,

I design a report with an SQLExpressionField. When I change datasource at runtime:


                reportClientDoc.getDatabaseController().setTableLocation(table, tableNew);

I got this error:


ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter -  detected an exception: Failed to parse expression.
	at com.crystaldecisions.reports.reportdefinition.SQLExpressionFieldDefinition.ta(Unknown Source)

How should I handle SQLExpressionFields?

I am using CRJ (2.0.1.r566)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Error was gone after using 12.2.203.r678 version

Answers (1)

Answers (1)

0 Kudos

Could be a couple of reasons.

You can't use SQL SELECT statments in SQLExpressions, they were not nor are they supported to be used this way.

SQLExpressions functions are defined in the Driver you are using so it may be you are not using the same Driver version as originally created with.

Need more info on the driver you are using and the Expression SQL you are using?

It may be you are failing to log on to the new server also.

Don