1220155 - SQL Query generated for the report in Crystal Reports, does not match the Record Selection Formula

• SQL Query does not match the Filters added on the report.
• Change made in the Record Selection Formula, are not reflected in the the SQL Query generated for the report in Crystal Reports.
• Why does this behavior occur and how to resolve it?

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

1. In Crystal Reports, open a report.
2. Update the Record Selection Formula.
3. Under the menu "Database", select "Show SQL Query..."
4. Notice the SQL Query does not reflect the update made in the Record Selection Formula.

• Under normal conditions, when adding a Record Selection Formula to a report, a WHERE clause is added to the SQL Query generated, representing the filtering criteria in the Record Selection Formula. However, if a report was originally created in Crystal Reports 8.5 and below, and the SQL Query had been manually modified ( This was an option in older versions of Crystal Reports ), then the SQL Query will not change. This is to ensure the customized SQL Query is maintained.
      
• If the report has been created in an older version of Crystal Reports 8.5 and below, and the SQL Query has been modified manually, then a 'Reset' button will appear when viewing the SQL Query in Crystal Reports.

• To let Crystal Reports generate the SQL Query for old reports where the SQL Query was manually udpdated, click the "Reset" button, in the "Show SQL Query" window.
    
1. In Crystal Reports, open the report.
2. Under the menu "Database", select "Show SQL Query"
3. If the SQL Query was manually modified in Crystal Reports 8.5 or below, a reset button will appear at the bottom of the window. Click on the "Reset" button.

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020