# 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
Crystal Reports

Last Comment
James0628
Raghavendra Hullur

Hi,
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?
If feasible, provide report with some saved data and information of suppress conditions
Mike McCracken

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
James0628

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts

TRUSTED BY