R
Robert Nusz @ DPS
Good Morning and Happy Holidays to all.
I've tried to resolve this issue, but not having any luck and would
appreciate some advice from those that have been there and done that.
I have two tables for driving records, primary key on (detail record) of
table one is used as partial key to index of table two (summary records).
There may or may not be summary records for a driver. Example of record set
would be record 010001 of primary table has secondary summary records
010001-001 and 010001-002.
On EACH record type, both primary (Detail), and secondary (summary) records,
there are three fields named: driver-name, owner-name, interested-party-name.
On each record (either primary or seconary) these fields MAY or MAY NOT have
a name in them (Null).
I'm not having problems identifying and reporting on these records, I get
the correct amount of names in the proper positions on my report. What I
need help in is this.
For each name of each record that has a value in it other than null value, I
need to print a copy of the report.
Example: 1 primary record only with driver-name and owner-name not null,
print only two copies of the report.
Example: 1 primary record with driver-name only.
1 summary record with driver-name and owner-name.
1 summary record with driver-name and interested-party-name.
would yield 5 copies of this report being printed.
This action needs to be controlled for each individual keyed record, that
way if I want to print a range of records, my number of printed pages stays
correct.
Any suggestions would be greatly appreciated.
Robert Nusz,
DPS, State of Oklahoma
I've tried to resolve this issue, but not having any luck and would
appreciate some advice from those that have been there and done that.
I have two tables for driving records, primary key on (detail record) of
table one is used as partial key to index of table two (summary records).
There may or may not be summary records for a driver. Example of record set
would be record 010001 of primary table has secondary summary records
010001-001 and 010001-002.
On EACH record type, both primary (Detail), and secondary (summary) records,
there are three fields named: driver-name, owner-name, interested-party-name.
On each record (either primary or seconary) these fields MAY or MAY NOT have
a name in them (Null).
I'm not having problems identifying and reporting on these records, I get
the correct amount of names in the proper positions on my report. What I
need help in is this.
For each name of each record that has a value in it other than null value, I
need to print a copy of the report.
Example: 1 primary record only with driver-name and owner-name not null,
print only two copies of the report.
Example: 1 primary record with driver-name only.
1 summary record with driver-name and owner-name.
1 summary record with driver-name and interested-party-name.
would yield 5 copies of this report being printed.
This action needs to be controlled for each individual keyed record, that
way if I want to print a range of records, my number of printed pages stays
correct.
Any suggestions would be greatly appreciated.
Robert Nusz,
DPS, State of Oklahoma