I have a report that draws the data from a schema file and I can not change the schema file to include more filters (parameters) on the form.

So I added a subreport with a parameter. However when I run the report and choose the parameter, it does unfortunately not filter on my main report.

 

Example:

 

 

Code    Description      Active (sub report field)

 

123      Hex Bolts            Y

456      Cylinders            Y

789      Rims                  **this would print "N" but I chose "Y" as my

                                     parameter**

 

When I run the report I can choose the "Active" parameter as "Y" or "N" and this does filter on what shows in the Active field, but it does not take away the lines in the main report.

 

Any suggestions or help please.

 

Thanks!