Crystal Report Notes

To suppress a field header if the data is blank

Section:
Section Formula: IsNull ({INVTRAXDEF.LACEY_INTENDED_USE})

Field Header:
Section Formula: if {INVTRAXDEF.LACEY_INTENDED_USE} = "" then true;

Field Detail:

To stop a field header section from repeating on multiple pages

Right click on the section that you want to apply the formula. Click selection expert

Open the formula menu next to “suppress (no drill-down). Enter the following:

if pagenumber<>1

then true

else false

How to create a new formula field

From View, open Field Explore. Right click, New.

Name the new field. Example: FormTitle

Create Formula

Formula example for single:
IF {HDRXXXXDEF.TITLE} = "QUOTATION" THEN "spanish translation" ELSE "exception"

Formula example for multiple:
IF {HDRXXXXDEF.TITLE} = "QUOTATION"
THEN "COTIZACION"
ELSE IF {HDRXXXXDEF.TITLE} = "ORDER ACKNOWLEDGEMENT"
THEN "CONFIRMACION DE PEDIDO"
ELSE IF {HDRXXXXDEF.TITLE} = "RMA ACKNOWLEDGEMENT"
THEN "CONFIRMACION DE RETORNO"
ELSE "UNTITLED";

Repeat formula until done. Save and close

Add new field to form