HP Intelligent Management Center Standard Software Platform User Manual

Page 637

Advertising
background image

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

Advertising