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

100

101

Pulling out a portion, or portions, of a text string

To extract the first letter of the customer name:

Crystal syntax example:

{Customer.Customer Name} [1]

Basic syntax example:

formula = {Customer.Customer Name} (1)

Extracting parts of a date

To determine what month an order was placed:

Crystal syntax example:

Month ({Orders.Order Date})

Basic syntax example:

formula = Month ({Orders.Order Date})

Using a custom function

To convert $500 from U.S. currency to Canadian:

Crystal syntax example:

cdConvertUSToCanadian (500)

Basic syntax example:

formula = cdConvertUSToCanadian (500)

20.2 Formula components and syntax

Formulas contain two critical parts: the components and the syntax. The components are the pieces

that you add to create a formula while the syntax is the rules that you follow to organize the components.

20.2.1 Formula components

Creating a formula in Crystal Reports is like creating one in any spreadsheet application. You can use

any of the following components in your formula:

Fields

Example: {customer.CUSTOMER LAST NAME}, {customer.LAST YEAR'S SALES}

2011-05-16418

Using Formulas

1 2 ... 413 414 415 416 417 418 419 420 421 422 423 ... 705 706

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 418

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