I need to develop a large report for Medicaid mental health billing
purposes that will easily have over 700 separate data fields in it. The
current paper version is 22 pages The fields include simple check
boxes, text, long notes and many variables. Data will come from 15
different tables and there happens to be 16 sections to the existing
report. The sections will never change, but the amount of data for each
section can change significantly for each person being tracked. I use
sub reports and regions regularly to put out reports of 4-6 pages. The
big report can easily be broken into smaller sections. Smaller sections
would be great to control what goes in them and find problems. My
question is : how do you save these smaller sections while maintaining
their format and then combine them into one large, coordinated report?
Or is there a better way?
Looking through the Print documents seems to put everything into files
that are outside the database. Is there a way to save a formatted report
section in a table row, add the other report sections to that row the
same way, then combine all the sections like a simple 16 item report,
and then off to the printer? Of course everything has to eventually work
like lightening from a print report button. This topic seems familiar
from a R:Base meeting,but I clearly did not understand the concept at
the time. It's only kinda clear now.
Thanks
Tom Frederick
Jacksonville, Illinois
