on 10-29-2009 3:52 PM
We have a medication report that needs the last administration time displayed. Can anyone help with a selection formula that chooses the max date?
The easiest thing to do is sort by the date (descending), and show the first record, suppressing all others until the next medication, patient, or whatever your grouping is. This is done with a global variable: Set it to FALSE at the beginning of the group(s), suppress the detail line based on the value of the variable, and then set it to TRUE (which can also be done in the Suppress Format formula).
HTH,
Carl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.