If then record selection with multiple conditions
Using Crystal Reports to reference a View
My formula:
@mySelection
IF {V_JOB.TASK} LIKE "*IN"
AND {V_JOB.CLOSED} = "Y"
AND {V_JOB.DATE} >= {?FrDate}
AND {V_JOB.DATE} <= {?ToDate}
THEN {V_JOB.JOB} ELSE "FALSE"
My record selection
{V_JOB.LMO} = 'L' AND
{@mySelection}
This View contains several relevant fields. To make my record selection of
the view, I want to display all records that are equal to string in .JOB,
when string in .TASK like "*IN" and field .DATE = ?myDateRange and field
.CLOSED = 'Y'
so I wrote the equation to do exactly that, but the displayed records are
row JOB only when TASK,DATE,CLOSED are true. But I have multiple rows of
the same JOB where TASK,DATE,CLOSED is false that I also want to see.
So if there are 30 records for Job A and only 1 of those records has
@mySelection is "true" then I want to select ALL 30 records even if the
other 29 are "false". The way it is written it only displays the 1 true
record and not the other 29.
Can anyone provide some assistance on what I'm doing wrong? Is there a
"show all" command or perhaps I can save "true" JOBs in an array and then
reference the array as my record selection?
No comments:
Post a Comment