Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports Problem
Message
General information
Forum:
Visual Basic
Category:
Third party products
Miscellaneous
Thread ID:
00410912
Message ID:
00411047
Views:
13
Hi Chad,

Another way to write the Select expression would be:
iif(isNull({viewRequests.Date}),True, ({viewRequests.Date} <= {?EndDate} AND
{viewRequests.Date} >= {?StartDate}) OR {viewRequests.Date} <= Date (0 ,0 ,0))
HTH, Igor

>Thanks for replying but I finally figured out what the problem was. Crystal Reports actually cares what order you put your select expression formula in. I moved the isnull({viewRequests.Date}) to be the first condition and the parm check the second and it now works fine.
Igor Gelin
Database Developer
Previous
Reply
Map
View

Click here to load this message in the networking platform