Hello,

CR2008
Oracle 11g

Using this FAQ I'e been trying to create a report that has repeating labels based upn a number field if an isnull condition is met. Here is my selection formula:

if isnull({VW_LOAN_ITEMS.ID_NUMBER})
then {VW_LOANS.TOTAL_ITEMS} >= {VW_CATALOGUE.MKEY} and
(select {?Choose}
case "By Loan Number" : {?Choice}={VW_LOANS.LOAN_NUMBER}
case "By Loan Object Number" : {?Choice}={VW_LOAN_ITEMS.ID_NUMBER}
case "By Lender" : {?Choice}={VW_LOANS.NAME})

else
select {?Choose}
case "By Loan Number" : {?Choice}={VW_LOANS.LOAN_NUMBER}
case "By Loan Object Number" : {?Choice}={VW_LOAN_ITEMS.ID_NUMBER}
case "By Lender" : {?Choice}={VW_LOANS.NAME}

Instead of creating a repeater table, I am using a Key field from an unrelated table. If I leave the CATALOGUE table unlinked, the report works for neither condition, if I link it through either and inner or left outer join, it works for only the else condiditon (but shows on correct record), and if I link it using the >= join, it works for only the isnull condiditon (duplicating the record based upon TOTAL_ITEMS regardless). My data is all contained in the Details area of the report.

Is there any way to fix this?

Thanks.