Filter multiople subbforms based on criteria from main form

[PinkLady50]

I have a report with multiple subreports. It is setting and linking together. I am getting too much data in my subreports and I need to filter the subreports on two fields: ContractNum and TaskOrder. Right now the subreports are giving me data for all contracts and taskorders but I need it to provide data for each ContractNum and TaskOrder that ties to the IssueKey on the subreports.Main Report


MTFDTF Contractor ContractNum Task Order etc

SubReport (this report is based on a query where the IssueKey is "P") There are a total of 5 subreports all setup with IssueKeys of "V", "C", "H", "T"

Description ContractorReason ContractorOnset ContractorResolved


The subreport is showing all records with an IssuesKeys of "P" but I want to filter it so that for each ContractNum and TaskOrder only the associated "P" issues are listed. This would be the same for all the other IssueKeys.

I have included a document with my report layout and the main report query and one subreport query.

I would appreciate any help you can provide.

[aytee111]

Link the subreports to the main report using the Link Master and Link Child properties on the subreport object.

[PinkLady50]

I am linking them with the IssueID and both the main and subreports are running. Now I need to filter the subreport to only provide information for each ContractNu and TaskOrder.

[aytee111]

Link them using those fields as well.

[PinkLady50]

How do I link them? The Master/Child only has one field.

[PinkLady50]

Do I link them through the query?

[aytee111]

Link them:
field1;field2;field3

[PinkLady50]

Thanks a million! I didn't realize I could add multiple criteria to the links!

[aytee111]

YW. Sorry it took me so long to realize your issue!