Using "OR" operator to suppress details 1

[itsuit]

I'm trying to write a formula to suppress details for records that don't meet 1 of 2 criteria. What I've tried looks like this:

{RESERVE.RESERVE_CODE} <> 'INITIAL' Or
Sum ({RESERVE.DELTA_AMOUNT}, {CLAIM.CLAIM_NUMBER}) < 15000

This is being done via the formula button in the Details Section Expert. The first part works fine, but when I add the criteria for the dollar amount it all fails and everything is suppressed. Any suggestions?

 

[lbass]

There is nothing particularly wrong with your formula. The second clause is suppressing based on the group total, and apparently the group total for the claim number is greater than or equal to 15000.

-LB

 

[lbass]

On second thought, do you mean you want to evaluate only the sum of "initial" records per group? If so, create a formula like this:

//{@initamt}:
if {RESERVE.RESERVE_CODE} = 'INITIAL' then
{RESERVE.DELTA_AMOUNT}

Then use a suppression formula like this:

RESERVE.RESERVE_CODE} <> 'INITIAL' Or
Sum ({@initamt}, {CLAIM.CLAIM_NUMBER}) < 15000

-LB

 

[synapsevampire]

You use the record selection to include rows, not suprees them.

Anyway, try:

(
{RESERVE.RESERVE_CODE} <> 'INITIAL'
or
Sum ({RESERVE.DELTA_AMOUNT}, {CLAIM.CLAIM_NUMBER}) < 15000
)

In the Report-?Selection Formula->Group

-k

 

[itsuit]

Thank you both for your responses. synapsevampire, your formula worked for me; I just had to change the criteria because I was trying to *include* records with a RESERVE_CODE of 'INITIAL' or a sum of DELTA_AMOUNT greater than or equal to 15,000, which is why I was trying to suppress records that didn't meet that criteria.

I appreciate your assistance!

--------
Kyle