SAP Knowledge Base Article - Public

1231830 - Grouping on a range

Symptom

Customer has a report and needs to group on ranges as opposed to specific values

Cause

Attempting to group on a range formula is not allowed in Crystal Reports

Resolution

Use conditional logic to place a literal value to each range, an example being:

if (field) in [1 to 7] then "Low" else

if (field) in [8 to 12] then "Med" else

"High";

 This formula will be allowed by Crystal because a literal value is the final output.

Keywords

grouping, range , KBA , BI , Business intelligence solutions , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2