Genius123
asked on
Crystal Reports Filter
Hello,
I have a filter that uses one parameter, and few other criteria. Here it is:
Local NumberVar Index;
Local BooleanVar Include := False;
For Index := 1 to UBound({?Product Type}) do
Include := Include OR {tblRevisions.ProductResul tBDHC} LIKE '*' & {?Product Type}[Index] & '*';
Include and
{tblRevisions.Engineer} = {?Engineer} and
{tblRevisions.Engineer} <> "" and
{tblRevisions.CheckerCompl ete} >= {?Start Date} and
{tblRevisions.CheckerCompl ete} <= {?End Date} and
{tblRevisions.DrawingStage } = {?Stage}
What I also need to add to the filter is this and I'm not sure how:
if {?RD} = True
include {tblRevisions.JobNumber} > 0
else
include all {tblRevisions.JobNumber} except where {tblRevisions.JobNumber} > 90000 and < 100000
Thanks,
Joel
I have a filter that uses one parameter, and few other criteria. Here it is:
Local NumberVar Index;
Local BooleanVar Include := False;
For Index := 1 to UBound({?Product Type}) do
Include := Include OR {tblRevisions.ProductResul
Include and
{tblRevisions.Engineer} = {?Engineer} and
{tblRevisions.Engineer} <> "" and
{tblRevisions.CheckerCompl
{tblRevisions.CheckerCompl
{tblRevisions.DrawingStage
What I also need to add to the filter is this and I'm not sure how:
if {?RD} = True
include {tblRevisions.JobNumber} > 0
else
include all {tblRevisions.JobNumber} except where {tblRevisions.JobNumber} > 90000 and < 100000
Thanks,
Joel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER