Set up a dynamic filter on a report in Parent table based on content in Child records

.. building  on what Kigsly said above, you van use a Summary Report on the child table to get the result you are looking for.  It is also possible to provide a link in the summary report which will take you to the Parent record instead of the children, as your goal is to get to a Parent, I believe.