HP Intelligent Management Center Standard Software Platform - Manual (Page 637)

Else if {?GroupBy} = 'Country' then
{Customer.Country}
Else if {?GroupBy} = 'Order' then
ToText({Orders.Order ID})
Note:
Crystal Reports formulas do not allow conditions to return different data
types. Both the Customer Name and Country fields return strings, so the
ToText function must be used to convert the Order ID from a number to
a string as well.
8. Save your formula and close the Formula Workshop.
9. In the Group Expert, select the GroupField formula as your group field,
and click OK.
10. Customize summary fields and section formatting as you like.
Users can now change the grouping presentation of the report by modifying
the GroupBy parameter value on the Parameter Panel.
Note:
Changing parameter values will not cause a database refresh as long as the
parameter is a non-data parameter.
Related Topics
• Data and non-data parameters
Crystal Reports 2008 SP3 User's Guide 637
23 Parameter Fields and Prompts
Advanced parameter features