Error Message: "The formula syntax is not supported by the report"

[Former Member]

We are using 'Development Environment: SAP Crystal Reports, version for Visual Studio 2010 u2013 Standard ' and using CrystalDecisions.CrystalReports.Engine and CrystalDecisions.ReportAppServer APIu2019s

I am reading SQLExpressionFields from one source .rpt file & want to add it to another ReportDocument. While doing so, it gives an error " The formula syntax is not supported by the report"

doc.ReportClientDocumentDataDefController.FormulaFieldController.Add(formualField); // formualField is SQLExpressionField from source ReportDocument

But when I tried to Add FormulaField, it succeeds

Please help me in knowing how to add SQlExpressionFields to ReportDocument.

Regards,

-atul

[former_member11696 · Accepted solution]

Hi Atul,

I don't believe CR allows you to do anything with SQL Expressions in code, only through the Designer.

Don

[former_member183750 · Accepted solution]

I did a bit of research and asking around on this and have to concur with Don. There is nothing in RAS SDK. CR.NET SDK has the ability to get and possibly modify existing SQL Expressions, no way to add new ones though.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

Thanx Don & Ludek for the reply.

CR provides support for addition/modification of SQLExpressions.

- - - - -

CRAXDRT.Application application = new CRAXDRT.ApplicationClass();

CRAXDRT.Report innerReport = application.OpenReport(path, CROpenReportMethod.crOpenReportByTempCopy);

innerReport .SQLExpressionFields.Add(name, strSQLExpression)

- - - - -

CRAXDRT.dll provides support for addition/modification of SQLExpression fields. But its not compatible with 64bit.

Just curious to know, is there any future plan to provide support for add/modify SQLExpression fields?

Thanx

-atul

Edited by: Atul Chivate on Aug 21, 2011 6:13 PM

[former_member183750 · Accepted solution]

The code you show is from the retired RDC SDK. The .NET SDK is close to the functionality of the RDC, but not quite there yet. There is some effort being extended to making the .NET SDK equivalent to the RDC, but there are no milestones as such. Adding this to the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports] will be a very good thing to do.

- Ludek

[Former Member · Accepted solution]

Thanx Ludek for the reply.

I have posted suggestion at '[SAP Idea Place |https://cw.sdn.sap.com/cw/ideas/5598]

-atul