Skip to Content
0
Former Member
Jan 08, 2008 at 05:36 PM

Problem with "or" in record selection

18 Views

Post Author: computerlady

CA Forum: General

I am having a problem using "or" in the record selection of my report. I have three dates in the database and if any three of these dates falls into the parameters, I want my records to show up on my report. However, it is only showing records for the first date. I have been working on this for a week now and cannot seem to get past this. Any ideas? I am using Crystal 11.

if {Date Requested} in {?Date Range} then true orif {Date Completed} in {?Date Range} then true orif {Date To Be Reviewed} in {?Date Range} then true else false

I have also tried this:

{Date Requested} in {?Date Range} or {Date Completed} in {?Date Range} or {Date To Be Reviewed} in {?Date Range}