I have a set with a parent table and a child table. The parent table is called "Admin," and contains the Date, Time and Case Number of a particular event. The child table is called "Persons," and contains "people" and "vehicle" data. Some records have information about people, i.e., name, address, phone no., etc, and some contain information about vehicles, i.e. tag number, state, year, make, model, etc., and some contain both.
That being said I have a report called "Juvenile Report." It normally contains one record from the Admin table, and one or more from the child table. Due to our agency's rules, this particular report can only contain ONE juvenile offender on a single report. So for example if an officer comes across two kids skipping school and wishes to write a Juvenile Report, the system will produce two identical reports with the same header information from the parent table, and one with the first kid's name and address, etc., and one with the second one's name, address, etc. So far this is no problem, because I have a group break in the report based on the record number of the "Persons" table, and I start each new group on a new page.
But here's my problem. If these kids were in a vehicle at the time of the stop, then the record containing their vehicle information needs to be repeated on each of their reports. The situation I'm encountering is that since the vehicle information is located in a third "Persons" record, each time I produce the printed report, I actually get three reports. The first two list the header info and one each of the kid's names, and the third one with just the vehicle information, since the group break doesn't know the difference between people and vehicles, it just knows that there are three records in the "Persons" table with the same linking key, so it handles all three as three different people.
So what I want to do is produce is two reports, with a different juvenile's name on each one, but with the same vehicle information repeating on both.
I tried placing the vehicle information in a sub-report and putting it in the group footer, but that didn't work either, so I'm wondering if this is even possible.
Any thoughts on how to do this?
That being said I have a report called "Juvenile Report." It normally contains one record from the Admin table, and one or more from the child table. Due to our agency's rules, this particular report can only contain ONE juvenile offender on a single report. So for example if an officer comes across two kids skipping school and wishes to write a Juvenile Report, the system will produce two identical reports with the same header information from the parent table, and one with the first kid's name and address, etc., and one with the second one's name, address, etc. So far this is no problem, because I have a group break in the report based on the record number of the "Persons" table, and I start each new group on a new page.
But here's my problem. If these kids were in a vehicle at the time of the stop, then the record containing their vehicle information needs to be repeated on each of their reports. The situation I'm encountering is that since the vehicle information is located in a third "Persons" record, each time I produce the printed report, I actually get three reports. The first two list the header info and one each of the kid's names, and the third one with just the vehicle information, since the group break doesn't know the difference between people and vehicles, it just knows that there are three records in the "Persons" table with the same linking key, so it handles all three as three different people.
So what I want to do is produce is two reports, with a different juvenile's name on each one, but with the same vehicle information repeating on both.
I tried placing the vehicle information in a sub-report and putting it in the group footer, but that didn't work either, so I'm wondering if this is even possible.
Any thoughts on how to do this?
Comment