Filtering and Grouping Report data based on option group

B

billmahon

I have a report with a bar chart. I want to be able to print a seperate
report for each of three categories. The user will select the category they
want to print using an option group.

I have included a grouping level on the report to seperate the category
graphs on each sheet. This works when I open the report directly (all
records show), and i get three nice charts showing the data specific to each
category on its own page.

The issue is when I try to pass the category name using the option group on
the other form. I get a blank page. I suspect this has to do with the
grouping level, but I can't figure out how to solve this. Can anyone help?

The reports record source contains the category names, and the graph and
report recored source are connected though the master child fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top