I propose replacing all* the pre-made reports with a single "Generate Reports" page.
ere are some of my ideas for what I think this page should include:
- A list of custom reports created by the client.
- On each one, they can enter a start and end date/time (more on this later) and click "Generate Report". Simple as that.
- There should also be an "Edit" button so they can make changes to the report.
- A "Create New Report" button and a "Show Archived" button.
- Creating or editing a report brings up an editor, which has the following options:
- Archive (a toggle box)
- Report Name
- Report Type: a drop-down menu with a list of options (users, permits, violations, payments, etc.). This tells the system what database table to pull from.
- Date/Time Range: which date/time column to use when generating the report for a given range.
- For example, if the report type is "violations", the options would be "issued date" and "due date".
- Add Column: this could look similar to offence items in the violation editor, where there's a button that creates a drop-down menu:
- Each menu has a list of options based on what columns are in that database table.
- There should probably be nice column titles instead of copying the column names from the database.
- Not every column in the table needs to be made available; some are unnecessary to the client and might just cause confusion.
- Each one also has a "Remove" button next to it.
- Save
*The exception is pre-made reports with a specific purpose, such as the MTO report, NIC letter report, or repeat offenders list.