SAP 7090310 Datový list stáhnout pdf (Strana 490)

100

101

21.12.11.1 To add dynamic grouping using parameter fields

Create a report using the sample data, Xtreme.mdb, and place the following fields from left to right

in the Details section:

{Customer.Customer Name}

{Customer.Country}

{Orders.Order ID}

{Orders.Order Date}

{Orders.Order Amount}

Create a new parameter field and call it GroupBy.

Select String from the Type list.

Add the following values to your parameter:

• Customer

• Country

• Order

Select Editable from the Show on (Viewer) Panel list, and click OK.

Create a new formula field and call it GroupField.

Type the following formula into the Formula text box.

If {?GroupBy} = 'Customer' then

{Customer.Customer Name}

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.

Save your formula and close the Formula Workshop.

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.

Komentáře k této Příručce

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema

SAP 7090310 Datový list Strana 490

Komentáře k této Příručce