rporter45
asked on
Crystal Reports Suppression Criteria
Hi there,
I have what I thought was simple suppression criteria for my group but it's not returning the results I need, ;
if {?Days Over Due} = "All Pledges" then FALSE
//less than thirty days overdue but not negative or 0 *this returns negatives as well as values over 29
else if {?Days Over Due} = "Less than 30"
then ({@Days Overdue} <=0
and {@Days Overdue} >29)
//inclusive of 30 and 90 excluding less than 30 and greater than 90 *this returns similar results
else if {?Days Over Due} = "Between 30 and 90"
then ({@Days Overdue} <30
and {@Days Overdue} >90)
//inclusive of all over 90
else if {?Days Over Due} = "Greater than 90"
then {@Days Overdue} <=90
Any help would be appreciated!
Thank you - CS
I have what I thought was simple suppression criteria for my group but it's not returning the results I need, ;
if {?Days Over Due} = "All Pledges" then FALSE
//less than thirty days overdue but not negative or 0 *this returns negatives as well as values over 29
else if {?Days Over Due} = "Less than 30"
then ({@Days Overdue} <=0
and {@Days Overdue} >29)
//inclusive of 30 and 90 excluding less than 30 and greater than 90 *this returns similar results
else if {?Days Over Due} = "Between 30 and 90"
then ({@Days Overdue} <30
and {@Days Overdue} >90)
//inclusive of all over 90
else if {?Days Over Due} = "Greater than 90"
then {@Days Overdue} <=90
Any help would be appreciated!
Thank you - CS
If feasible, provide report with some saved data and information of suppress conditions
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Suppression condition result should be a Boolean value. First 3 conditions always results in false as 2nd and 3rd are:
else if {?Days Over Due} = "Less than 30"
then ({@Days Overdue} <=0
and {@Days Overdue} >29) --> this will always be false since Days Overdue will be a single value and you are trying to check for 2 values using and conditions
//inclusive of 30 and 90 excluding less than 30 and greater than 90 *this returns similar results
else if {?Days Over Due} = "Between 30 and 90"
then ({@Days Overdue} <30
and {@Days Overdue} >90) --> here also same as above.
The 4th condition also looks contradictory.
Can you provide the details of exactly the 4 conditions and whether the report section needs to be suppressed or displayed for those? conditions?