Well, I would try to do a find on the time period, then switch to a summary
layout. That layout should contain 2 sub-summary parts. Create a summary field
that sums the number of patients (patno) and put it on a sub-summary part sorted
by physician. You may want to put the field for physician name on the same layout
part. Create another sub-summary part sorted by clinic location. Put the summary
field patno on that layout together with the clinic location field. Make a script
that takes the user first to a find request to search for the right time period,
then sorts the found set for physician and clinic location, and finally shows the
summary layout in preview mode with the option to print (pause step, then print
setup and print steps in script). If I didn't forget anything, this should work.
I'm sure you'll figure it out with these tips.
Swedish Museum of Natural History
> Let me try this question again (No previous responses)...
> I'm sure this is pretty straightforward but I can't seem to get it right. I've
> got physicians who go to different clinics where they see patients (and
> generate letters). I want to create a summary report layout that will tell me
> the numbers of patients seen within a specified time period for each physician
> as well as the number of patients seen for each physician at each clinic
> location. There are some other ways I'd like to break down the data but once I
> know how to do this, I suspect the rest will be simple. Any advice would be
> appreciated. Thanks alot.