2345921 - Crystal Reports not displaying unique values in group header

SAP Knowledge Base Article - Public

2345921 - Crystal Reports not displaying unique values in group header

Symptom

  • A field has the same values with upper and lower case character(s) for example "Value" and "value"
  • After grouping by this field, only one of the upper/lower case values are shown in the group header

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Create a report based on a dat source that has "Value" and "value" records in a specific field
  2. Create a Crystal report with group by that field
  3. Observe that only "Value" or "value" is displayed in the group header, but not both

Cause

  • This is a by design behaviour of the product
  • By default Crystal Reports is not case sensitive in the grouping

Resolution

  1. Go to File >> Report options
  2. Uncheck "Database Server is Case-Sensitive"
    DatabaseServer.jpg
  3. Refresh the report

Keywords

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

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016