Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help with Crystal Reports formula... Not sure how to
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Need help with Crystal Reports formula... Not sure how to
Miscellaneous
Thread ID:
00581809
Message ID:
00581809
Views:
56
I am not sure how to write the following code in Crystal Reports. I am putting the code in the Group Section_visibility area. So I don't show times in my report that don't meet the criteria. Here's the criteria. If a time exists and it is between 30 and 90 seconds then show it. And I compare FA time to FB time so I know which time between FA and FB to look at in the 30 to 90 seconds range.
Here's my code which gives me an error because the syntax is longer correct since I added the FB time variable to the mix. Thanks for the help. I will keep working on it too.
If 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}) then
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})>90

If 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}) then
Time({master.T_SHOCK})-Time({master.T_FB_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FB_ATPT})>90

If IsTime ({master.T_FA_ATPT}) and Not IsTime ({master.T_FB_ATPT}) and IsTime ({master.T_SHOCK}) then
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})<30 or
Time({master.T_SHOCK})-Time({master.T_FA_ATPT})>90

If Not IsTime ({master.T_FA_ATPT}) and IsTime ({master.T_FB_ATPT}) and IsTime ({master.T_SHOCK}) then
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