2345921 - Group name not displaying unique values in Crystal Reports

• A field has the same values with upper and lower case character(s) for example "Value" and "value".
• After grouping on a database field in Crystal Reports, only one of the upper/lower case values are shown in the Group Header.
      
        
• Note: Image and data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

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

1. In Crystal Reports, create a report based on a data base that has values that are different based on the case senitivity. For example: "Value" and "value".
2. Create a group on the database field.
3. Observe that only one group is displayed when expecting multiple groups for case sensitive value. For example: It only creates a group for "Value" and "value".

• This is normal because by default Crystal Reports is not case sensitive when grouping.

• To set a report to be case sensitive in Crystal Reports, check the option "Database Server is Case-Insensitive" 
  
  
1. In Crystal Reports, open the report.
     
2. Under the menu "File", select "Report Options..."
       
3. In the "Report Options" window, uncheck the option "Database Server is Case-Insensitive"
      
    
      
4. Save the report.

Crysta, Reports, 2013, 2016, group, grouping, header, gh, by, case, sensitive, lower, upper, case, lowercase, uppercase, distinct, unique, value, separate, display, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem