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

• 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

• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

CR, SQL Expression , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To