Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Problem
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Miscellaneous
Thread ID:
00671061
Message ID:
00671065
Views:
17
What happens if you change
IF TRIM({RPTINFO.TITLE1}) = "" THEN
to
IF LEN(TRIM({RPTINFO.TITLE1})) = 0 THEN
>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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform