Multiple filters for different reports
I am building a user control where the user can set a bunch of filters and then display a report based on those filters.
Example of reports:
- sum of sales grouped by customer,
- detailed list of sales for a customer,
- sum of sales grouped by salesperson,
- ...
Example of filters:
- date from,
- date to,
- customer,
- salesperson,
- ...
This is just an example, in my project there are many filters and even more reports. The tricky thing is that reports need different filters. For example, the report 'sum of sales grouped by customer' need only the 'customer' filter, and 'detailed list of sales for a customer' needs the 'customer', 'date from' and 'date to' filters.
I am wondering how to design the interface for this user control. I see two options:
All filters on one side and the list of reports on the other side. User can set filters, select report and display it. What I don't like about this is that the user doesn't know easily which filters are needed for a report. Here I could enable/disable filters based on selected report (if the user selects the first report, only 'customer' filter would be enabled, and for second report the 'date from' and 'date to' filters would be enabled also).
Each report in own tab or some other container. When the user selects a report, only relevant filters are displayed.
I'm not a fan of either of those two options... any other ideas?