Crystal 11 - get LTD transactions when there is a transaction today

[Martin McGovern]

Hi all!

I work for a pharmacy and our state board is asking for a daily report that shows all prescriptions dispensed today and, in addition, if the patient received their prescription today they also want to see all life to date transactions for that patient.

So, if nothing is dispensed today, the report is blank. If we do dispense to {dispense.patient} today, it needs to show all previous transactions (in some cases going back years).

The trigger is the dispense date {dispense.date}. However, any filter for {dispense.date} seems to limit my prescriptions {dispense.rx#} to only that date. Banging my head on the wall, so appreciate any ideas you may have.

Thank you!
Martin

 

[pmax9999]

The basic approach here is to use the same table twice, joined on patient ID. When you add the table the second time it will give it an alias by adding "_1" to the name.

You then use the first instance of the table to identify the patients with a transaction today (by referencing it in the Record Selection) , and the 2nd instance to return all transactions for those paients, ie put the fields from this table on the report.

Hope this help.

If you need furher assistance, provide table and field names and we can be a bit more specific.

Cheers
Pete