Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Crystal Reports Problem
Message
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Produits tierce partie
Titre:
Crystal Reports Problem
Divers
Thread ID:
00410912
Message ID:
00410912
Vues:
36
I want to include in the report all of the records whose date is between the parms startDate and endDate and any records that have an empty date field.
the formula I am using in the select expert is this:
({viewRequests.Date} <= {?EndDate} AND {viewRequests.Date} >= {?StartDate}) OR
{viewRequests.Date} <= Date (0 ,0 ,0) OR
isNull({viewRequests.Date})
but it doesn't show any records that have empty dates (They are being filtered out), But the records whose dates are between the parms are working fine. Please help me on this?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform