SAP Knowledge Base Article - Preview

2345437 - Can we use a subquery in a SQL Expression Field in Crystal Reports?

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.