Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditionally Duplicating Records in a report

Status
Not open for further replies.

auylox

Technical User
Feb 7, 2007
20
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top