SAP Knowledge Base Article - Preview

2525150 - SQLExpressions registers incorrect data type when adding to record selection formula

Symptom

When our custom code that uses Crystal APIs Introduce SQLExpresssions, there data type is inherently seen as string regardless of the datatype specified. This gets corrected only when we open the template in designer and open the SQLExpression field and save it back.


Read more...

Environment

Crystal Reports for Visual Studio SP 19 and above

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio

Keywords

CR for VS, SQLExpresssions, FormulaFieldController, CrFormulaSyntaxEnum.crFormulaSyntaxSQL, SP 22 , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.