Working within groups conditionally
Posted on 2012-03-30
I simply cannot wrap my head around working within groups. Can someone explain to me how limiting formulas to just what's inside groups works? What techniques/tutorials can you share that would shed some more light on this subject?
My problem is that I have a report that contains data grouped by Patient Name. The report's group header needs to show if Document A, B, C or D is due or needs to be signed.
1. If Document A has not been created for the patient of the group, then show "Create document A"
1a. If Document A was created, but not signed, show "Sign Document A"
Note: I would also need to be able to show messages based on name of document, user of document, not just dates.
The logic would pretty much continue from there. The groups can have an infinite amount of records returned based on how many documents have been created at the time the report was run.
Maybe if we could work out a solution for this example, it might help me understand the logic a bit more.