SAP Knowledge Base Article - Public

1231830 - Grouping on a range


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


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


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


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


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


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