I'm trying to put together a report to track our record reviews. In order to not have duplicates I have a condition to suppress a row if it's a duplicate
{review.clientNo} = Previous({review.clientNo})
and it works fine.
For who knows reasons one of our employees who does not do record reviews has access to two fields that relate to the tables of the record reviews and they keep checking off these fields even though they don't need to. So even if that particular record was not reviewed it still shows up on the report because two fields within it have entries. Until we can undo that we still want to run the reports. So I want to have two conditions to suppress either the one i have typed or the one in which only those fields are present and all others a null
This is what I have so far but crystal reports isn't liking it.
{review.clientNo} = Previous({review.clientNo})
or isnull( {review.initialDate} + {review.followUp} +
{review.code47A} +{review.clientSales} + {review.totalSales} +
{review.salesQuantity} +{review.clientSatisfaction} + {review.clientAddress}
+ {review.clientEmail} +{review.clientNumber} + {review.orderNumber} +
{review.orderTrack} + {review.orderFill} + {review.orderAmount} +
{review.orderSize} +{review.deliveryMethod} + {review.salesDate} + {review.orderDate})
Create a formula called suppression
if
{review.clientNo} = Previous({review.clientNo}
or
(
isnull({review.initialDate})
AND isnull({review.followUp})
AND isnull({review.code47A})
AND isnull({review.clientSales})
AND isnull({review.totalSales})
AND isnull({review.salesQuantity})
AND isnull({review.clientSatisfaction})
AND isnull({review.clientAddress})
AND isnull({review.clientEmail})
AND isnull({review.clientNumber})
AND isnull({review.orderNumber})
AND isnull({review.orderTrack})
AND isnull({review.orderFill})
AND isnull({review.orderAmount})
AND isnull({review.orderSize})
AND isnull({review.deliveryMethod})
AND isnull({review.salesDate})
AND isnull({review.orderDate})
)
then 1 else 0
in the suppression for your header and footer try this
sum({@suppression},{fieldgroupedon}) =0
You could also, by the way, now change your detail record suppression to just
{@suppression} = 1
I hope I got all that right!