Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help with Crystal Reports formula... Not sure how to
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Need help with Crystal Reports formula... Not sure how to
Divers
Thread ID:
00581809
Message ID:
00581809
Vues:
57
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.
Répondre
Fil
Voir

Click here to load this message in the networking platform