I have 2 formula fields in the header of my report, with field
one positioned above field 2.
If the data field for field 1 is empty, I want to populate
field 1 with the data from field 2.
The VB syntax function for field 1 is:
IF TRIM({RPTINFO.TITLE1}) = "" THEN
Formula = {RPTINFO.TITLE2}
ELSE
Formula = {RPTINFO.TITLE1}
END IF
The problem is, if field 1
is empty in the table, field 2
does not display.
Any thoughts?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people