I have a table (tblLabIssues) and a report (rptLabIssues) that have the following fields:
Lab
System
OpenedDate
ClosedDate
Issue
Impact
Resolution
I need to be able to filter the report on Lab, System, and ClosedDate. My initial thought was to put either some buttons on the report itself to filter, but I guess buttons do not work very well on reports? If that is the case, what would be the best way to allow users to filter by any of those fields? If at all possible, I'd like the filtering to take place on the report so that the user can, for example, open the report to see every issue and then filter down to the Lab and then to only Open issues as needed.
Thanks for any help or insight you can give,
Keith