Filter a report

[btrini10]

Hi
I have a report that displays an identified issue on each page. There is a sub-report that shows all individuals who have been associated with that issue. So there is a 1 to many relationship between the main and sub-report. I have written some code that allows me to filter the main report by any of the fields. However, I would also like to filter the report by values in the sub-report. For example, if Joe Bloe is associated with 5 issues, I would like my filter to produce only those issues with which Joe Blow is associated even if there are other also associated with the issue.
Any ideas would be appreciated.
Thanks

 

[maxhugen]

Your data could be represented in a report in 2 different ways:

1. Show me Individuals by Issue
2. Show me Issues by Individual

You may not need a subreport. In your report, create a query which joins the Individual and the Issue.

If the aim is to show Issues by Individual, then add a group for the Individual. Show the Individual's details in the Group header, and the (one or many) Issue details in the report's Detail section.

HTH

Max Hugen
Australia

 

[btrini10]

Max
Thanks for the response. My main report has about 16 fields and in order to get it in the required format, I was not able to group, hence the sub-report.
I do have a query that joins the individual with the issue. On the query, any issue that has more than 1 associated individual has a record for each individual.
I would filter the query to achieve the search I desire but I already have a form that allows searches on the report and I would like to add the individual as another option by which to search.
Any other suggestions?