Activity codes

[ChipF]

I need two activity code dates (BK Date and DT Date) for an application on a report. I am using the BK activity code in the selection criteria since I only want booked loans. On the report they also want to see the DT date, which I assume occures after the BK code. I have the BK date on the report since it was driven by the BK activity code in the selection criteria. So how do I show a field with the DT date on the report?

There is a table with each loans activity codes and dates.
act.activity_code = 'BK','DT'
act.activity_date

There is a table with application info.
app.opr_app_nr

 

[IdoMillet]

Assuming each Application has at most only one DT and one BK records:

Join the application to the activity table. Then use Database, Add Database to select the Activity table a second time. Give an alias of Act_DT and join it in a similar manner.

In the record selection criteria use something like this:
--------------------------------------------------------
act.activity_code = 'BK' AND act_DT.activity_code = 'DT'
--------------------------------------------------------

This gives you a setup that behaves as if you have two separate activity tables: one for BK transactions and one for DT transactions.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com