I will soon be tasked with re-vamping a reporting page where users will be able to build their own reports to pull data from their database. My question to you is this: how would _you_ _actually_ build reports dynamically for users?
I want to know how YOU would actually do it, because I have Damien's book, and I have been to MST's talks. I know how THEY would do it. I want to know how other 'in the trench' programmers would do it.
The interface is static, where they can select checkboxes to bring in more data, fill in date range fields. The selection of data is actually pretty mundane, except that a checkbox means that I want all rows of type 'X' where 'X' actually has a number of conditions attached. In the end it isn't that difficult of a concept, except it isn't trivial enough for simple DBIx::Class abstractions.