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.
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.