Need Impromptu 7.0 rpt to use as input for another report

[gpilgreen]

From my medical billing database, I am trying to determine what type of payments are being made on bad debt accounts once the account has been writte off to bad debt. The bad debt accounts and the dates that they are written off is coming from the first report. Now, I need to use that report to see what payments were made after it was written off and what type of payment (patient, insurance, legal settlement, etc.) was made to each account.

I have a report that pulls all records from the database that have the transaction type = "3013" that also have a posting date from 1/1/2010 thru 12/31/2010. It returns a list of accounts, with the transaction posting date, and some other fields that I need to report.

Now I need to find out the next payment transaction posted to that account that is after the posting date in the first report, "next" being the next posting dated record.

Can anyone help me decide what type of report to use with this? Is it appropriate to use a sub report?

Thanks,

 

[drlex]

This may be tackled with a Hotfile- the output of the first report can be used as a data source for the second. Note that there is no indexing on the Hotfile, so the second is unlikely to be fast.

soi là, soi carré