Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports Suppress Print Formula Suppressing All
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Crystal Reports Suppress Print Formula Suppressing All
Miscellaneous
Thread ID:
00582058
Message ID:
00582058
Views:
52
I want to suppress printing a line in my Crystal Report if it meets one of four conditions. How can I re-write this formula so it does not suppress all of the lines in the report all of the time? I tried several variations, but no help. I just removed some parentheses to make it easier to read. The four line suppression conditions are separated by the three capitalized OR words.
Thanks for the help.
IsTime ({master.T_FA_ATPT}) and
IsTime ({master.T_FB_ATPT}) and
IsTime ({master.T_SHOCK}) and
Time({master.T_FA_ATPT}) < Time({master.T_FB_ATPT}) and
(Time({master.T_SHOCK})-Time({master.T_FA_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})>90)
OR
IsTime ({master.T_FA_ATPT}) and
IsTime ({master.T_FB_ATPT}) and
IsTime ({master.T_SHOCK}) and
Time({master.T_FB_ATPT}) < Time({master.T_FA_ATPT}) and
(Time({master.T_SHOCK})-Time({master.T_FB_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FB_ATPT})>90)
OR
IsTime ({master.T_FA_ATPT}) and
Not IsTime ({master.T_FB_ATPT}) and
IsTime ({master.T_SHOCK}) and
(Time({master.T_SHOCK})-Time({master.T_FA_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})>90)
OR
Not IsTime ({master.T_FA_ATPT}) and
IsTime ({master.T_FB_ATPT}) and
IsTime ({master.T_SHOCK}) and
(Time({master.T_SHOCK})-Time({master.T_FB_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FB_ATPT})>90)
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Reply
Map
View

Click here to load this message in the networking platform