Any tips for custom report with Infomaker?

[Suzi T]

Hi Aria Users,

I've been tasked with creating a custom report via Infomaker that would ideally be as follows:

1. User enters date range

2. Report returns a list of patients whose final treatment is within that date range (using the task "Final Check - Physics" as a trigger)

3. List the date of the next scheduled follow up appointment (find the first "MD - Follow up" or "MD - Post treatment check up" appointment that has a status of "Open" "Manually Completed" or "In Progress")

4. If there is no follow up appointment, display "NONE"

5. List the status of the "Survivorship" task, no matter what date is associated with it

I am OK up to step 3.  

Please see attached for my report definition from Infomaker on what I have so far.

I would appreciate any tips or tricks you may have.

Thanks,

Suzi Topalian, MS

Medical Physicist

Sharp Chula Vista Medical Center