I need to create reporting application that gets information
from a query against an attached database. I've discovered
that process works well.
The difficult part stems from that fact that the report may consist
of several different forms each relating to a different subset of the
data returned by the query. Forms 1, 2, and 3 may make up one report,
forms 1, 4, 5 and 7 may make up another report and forms 1, 6 and 7 might make up a still another report.
It may take days trying to figure out the process. I'm thinking that I need to
1) execute my Query
2) if recordcount > 0 CreateFile
3) write data to the form 1 and do a writePage
4) for pages 2 to 7 test data to decide if form is needed,
if so load that form, write data to it, and then do a writePage for that form
5) get next record
6) when no more records closefile and send to previewDialog.
I. Does this make sense?
II. How do I load the individual forms?
A somewhat related question; when I insert a field to the form it comes
with an outline. How do I programatically hide that box.