Multiple filters for different reports

by sventevit   Last Updated September 21, 2018 10:16 AM - source

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:

  1. 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).

  2. 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?

Answers 1

Why not just; Main menu with report links. Once link / report is selected on top filters, below report.

September 21, 2018 10:04 AM

Related Questions

Fling cells in table view

Updated May 24, 2015 21:06 PM

Preventing users from closing browser tab. Bad idea?

Updated October 09, 2016 09:06 AM

How to control what user input in adding form .

Updated February 05, 2018 12:16 PM

Textbox with addon selector

Updated March 27, 2019 23:16 PM

Integrating "Browse" options and "Search" options

Updated August 04, 2015 13:07 PM