Combining 2 Reports

[vandy05]

I need to combine 2 reports into one Master Report. Instead of making one huge table with all the information, the data was split into 2 tables. They now want a report that prints all the information out on one page. Here is my issue:
Report 1 (master data) - asks for a parameter
Report 2 (personnel) - asks for 2 parameters
Report 2 (personnel) - can be blank
So if no personnel is entered, the entire report prints out blank.
Is there a way to allow report 2 to be blank???

 

[HiTechCoach]

I normally handle this with sub reports. I use a separate sub report to print data from a related table.

 

[vandy05]

I am using a subreport. This database is being used to keep all information on sites used for certain projects. See example below:

Report 1 - has info such as name, main contact, mailing address etc.
Report 2 - has personnel at each site
Report 3 - combination of report 1 and 2

Report 1 - asks the name of the main contact at the site
Report 2 - asks the name of the site, and the name of the project

So if no one is entered as a personnel for the site, the report 3 prints out blank even though there is information in report 1 but not in report 2.

 

[HiTechCoach]

Do you have the sub report linked to the parent report using the master/child linking fields?

Only the parent report will need to prompt for a parameter. The sub report should be linked to the parent report to print only the related records.

 

[vandy05]

How do you link the subreport to the parent report?
I am very new to Access. Trying to teach myself!
Thanks!!

 

[HiTechCoach]

If you view the property sheet for the sub form control, there are two properties, one for the master linking fields and one for the child linking fields.

 

[vandy05]

I am not really sure how to do that but here is what i do know.

Table 1 - ID (primary key), Site, Mailling Address, Shipping Address Etc.
Table 2 - ID (foreign key - relationship between ID in Table 1 is set up), Personnel Name, Phone, Fax Etc.

Each Site can have several entries in Table 2 or nothing can be entered if we do not know who the contacts are.

I have a report made for Table 2 using an autolookup query to add the site name and the project name. That way the information is relevant. I then added parameters in the query so that you can pull a specific site and projects contacts all together and ignore the rest.

I want a report that prints out all the data in Table 1 (I want to be able to use a parameter to pick out specific sites or projects if needed) and Table 2 (I want it to print blank if there is nothing in there with the same ID as Table 1)

I think I am supposed to use a type of join but I just can't figure it out.

Is this even possible???

 

[Dennisk]

you can prevent empty text boxes being printed by setting the can shrink property to yes/true

 

[vandy05]

That does not work.
I think I figured it out though using an outer join!