Symptom
Background: We create SQL conditions to support following features in Crystal Reports and we use SQLExpressions in some of the Reports.
- Upgrading from using the RDC to .NET
- To add security to the SQL Statement
- Many of our report templates are executed from our code via the SetDataSource approach. But the problem with the updated SDKs is that reports so created cannot utilize SQLExpressions in order to augment the report. When we add a SQLExpression as a report field and run.
Problem is we see multiple data rows, combination of both the SQLExpression connection and the Dataset connection.
Read more...
Environment
Crystal Reports for Visual Studio
Product
SAP Crystal Reports, developer version for Microsoft Visual Studio
Keywords
SQLExpression, DataSets, cr for vs, multiple data sources , 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.