1281732 - How to pass a SQL query to a Crystal reports in a Visual Studio .NET application?

• It is not possible to pass a SQL query to a Crystal Report using the CR assemblies in VS .NET

• This functionality was available with the Crystal Reports Report Designer Component (RDC) only
• The Crystal Reports designer also had this functionality up to version 8.5

• Use the Crystal Reports selection formula
• The only other SQL modification possible is with Command Tables accessed by use of the Report Application Server (RAS) APIs
• See the Report Application Server .NET SDK Developer Guide for more details

 

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio