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