ovrdrvn
-
Posts
4 -
Joined
-
Last visited
Everything posted by ovrdrvn
-
Slightly similar problem: I'm using the Go To Related Record to find all the related records of the found set in my table "visits". I need to have a count of the "patients" displayed in my original table/layout which is the "visits"child table. I was told there was a way to do it with a variable field and then a global field in the report...but I can't understand this. Anyone?
-
I've been tipped off to part of the answer after reading up on other posts: two variables where the first collects all of the IDs from the related or parent table; second variable is a counter. What I don't get is how to load the full set of IDs into the first field with some sort of delimieter and then how to loop through each and only up the ticker on the second variable fields if the ID is unique as there are sure to be dupes and we are only counting unique patients who've had care this year.
-
I'm working on something similar in terms of counting. These steps aren't working for me. I need to count the number of "unique" (or distinct in sql terms) IDs in the parent table that are associated with the found set in the child table. Patients is the parent table and visits is the child table. A found set over a time period of 42 visits might only mean 15 patients. My report in the child table needs to show how many unique patients were visited over the period (so the funders/govn't can appropriate the $)
-
I have two tables: patients and visits. A layout in the visits table gives a sub-summary report of the kinds of visits and actions performed over a given period. I need to find the actual number or unique or distinct patients based on the found set of visits (as one patient could have been visited more than once in a period). A Summary field of the Count variety works in the patients table, but is useless in the visits table. Help please! (for a good non-profit cause)