PPT Slide
I needed a way to create and then calendrically display the on-call schedule. It was simplest to create the schedule in a single flat-file table and then to use Xbasic to copy the dates and the associated on-call doctor to another table, suitable for generating the calendar report. The report groups by months. Every field on the report is a calculated field.
The details of this report (and the scripts) are not important--what is important is the concept of moving your data from the data entry table into a scratch table to make the reporting simpler.