Symptom
- How to add a subquery?
- Can we add a subquery in a SQL Expression Field in Crystal Reports?
For example:
Can we add the following SQL Query to a SQL Expression Field?
Select MyField_1, MyField_2
From My_Table
Where MyField_1 > 10
Or an subquery that calculate a summary like:
Select SUM(MyField_1), MyField_2
From My_Table
Where MyField_1 > 10
Group By MyField_2
Read more...
Environment
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Keywords
CR, SQL Expression , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
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.