Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

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

Creation date: 5/1/2021 10:09 AM      Updated: 5/1/2021 10:09 AM
Files   
DataImage25.png
29.5 KB
DataImage34.png
29.9 KB
DataImage34.png
93.6 KB
DataImage53.png
12 KB
DataImage53.png
98.3 KB
DataImage53.png
145.4 KB
DataImage70.png
6.2 KB
DataImage89.png
26.3 KB
DataImage89.png
29.9 KB
DataImage89.png
6.2 KB