where condition

[Guest]

Hello there,

I have a report with a sub report. The main section of the report will stay
the same. The sub report, however, I want to be filtered based on the
printing options the user selects. For example, if the user wants all
actions, then the report will print all records associated to the parent. If
the user selects "final decision" then I want only final decisions associated
to the main report to display. If the user selects 'issue only' then i want
no sub report to show, and only the main report information to display. How
can i do this?

Currently i have tried creating an option group with a if then else
statement, but it isn't quite working.

Any ideas? many thanks in advance,

 

[Duane Hookom]

You should filter the subreport's record source query.