Returning details on a second pass

[vblack7770]

I am using CR8.5 with and ODBC connection to my Oracle 9i DB. I would like to do the following and am finding it impossible in Crystal. Can I do this in Crystal, or do I have to create a view on the DB side?

Generic Explainatin: Pull all loan records and their detail fields that = value A. That is easy as that part is in the report selection criteria.
However, if one of the loan records that equals Value A has a value B in one of its detail fields, then I want Crystal to go and retrieve the same set of detail fields as it would for the Value A record, but for the Value B record.

Business Use Explaination: The report is for all 2nd lien loans whether my company owns the 1st lien or not. However, if the 2nd lien loan has a 1st lien with my company, then I want to go and pull all the detail records for that 1st lien loan #. The report will be a list of all 2nd liens where there is a 1st lien, however, depending on the value of one field (whether we own the first lien or not), the report will either pull all the fields for the 2nd lien loan OR all the same fields for the 1st lien loan.

Confusing enough? I thought about passing a parameter field based on the records that come back the first pass, but I am not sure if that would work, or how that is done.

 

[Madawc]

I think you need to add the same table twice, the second time as an alias. Then you can have distinct connections - but use Left Outer if the link may not be there and you still want the main details.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[vblack7770]

DUH!!!!! Oh my!! Thank you......I knew I was making it too hard....I need more caffiene.