SAP Knowledge Base Article - Public

1217147 - Crystal Reports Record Selection Formula change order when modifying it via the Select Expert.

Symptom

  • Record Selection Formula change orders.
  • In Crystal Reports, when modifying the Record Selection Formula using the Select Expert, it sporadically changes the orders of the filters.

Environment

  • Crystal Reports 9
  • Crystal Reports 10
  • Crystal Reports XI
  • Crystal Reports XI R2
  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a Record Selection using the Select Expert.
    • Under the menu "Report", select "Select Expert - Record..."
    • In the "Select Expert" window, create one or more selection.
    • Click "OK" to accept the change.
  3. Modify the Record Selection Formula from the Select Expert.
    • Under the menu "Report", select "Select Expert" -> "Record..."
    • In the "Select Expert" window, click on "Show Formula" to display the Record Selection Formula.

Select Expert.png

    • It will display the Record Selection Formula at the bottom of the screen.
    • Click on "Formula Editor..." to edit the Record Selection Formula.

Select Expert 2.png

    • Add filters to the Record Selection Formula at the end.

Select Expert - 03.png

    • Save and close the formula.
  1. Go back to the Record Selection Formula via the Select Expert, and notice the order of the filters have changed.

Select Expert - 04.png

Cause

  • This is a known issue that have been tracked under Problem ID: ADAPT00075318. 

Resolution

  • There is no product update that resolves this issue.
  • The suggestion is to not modify the Record Selection Formula via the Select Expert, but to modify it directly:
    1. In Crystal Reports, under the menu "Report", select "Selection Formula - Record..."
    2. In the "Formula Workshop", modify your Record Selection Formula.
    3. To save the change, click on "Save and Close"
    4. When modifying the Record Selection Formula directly, without passing via the Select Expert, the modification will be retained, and stay in the order it was written.

 

 

Keywords

Record selection formula order changes select expert Crystal Reports Select Expert Record Selection Formula Editor , c2015212 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2