Newbie requesting guidance on master-detail or sub-report solution
Posted: Wed Oct 11, 2006 4:14 am
This is my first stab at reporting and would like a few pointers before I shoot off in the wrong direction.
SQL tables, one with header records (instrument serial number, measurement start time, etc) one with details (instrument serial number, start time, this measurement time and measurement value). Master linked to details by (serial number and start time).
Report listing each selected master record, each item to include chart (line graph) of associated detail measurements).
What's the best way of generating this type of report?
Some guidance would be appreciated.
Many thanks
Ian
SQL tables, one with header records (instrument serial number, measurement start time, etc) one with details (instrument serial number, start time, this measurement time and measurement value). Master linked to details by (serial number and start time).
Report listing each selected master record, each item to include chart (line graph) of associated detail measurements).
What's the best way of generating this type of report?
Some guidance would be appreciated.
Many thanks
Ian