Ways of filtering in a report

[sabre1]

Can anyone tell me the different ways of being able to filter when in a report?
I know you can have a parameter when the report opens but what i am really looking for is a way where a user can select multiple options in report view and the report filters on them.
Example if i have a field which is Active_Closed where the user either puts in Active, Closed or Prospective how do i get the user to be able to filter on just active accounts or active and closed accounts when in the report.



Really need some help so any advice would be greatly appreciated.

[NTC]

generically speaking; reports are passive. They are the end result and one does not have an interative process with a report object.

Reports have a record source - generally a query, sometimes a table itself. It is at this level that one usually modifies the record source content. For an iterative process, that can be set up with a Form that holds criteria called by the query. For instance the user might put in the StartDate and EndDate in textboxes in a form - and then press an OpenReport button. The report is based on a query, the query is using the StartDate and EndDate info as criteria to define its record set.

Hope this outline helps.