Database Reporting Module

June 01, 05 by kenrich

Currently, I’m in the process of writing a reporting module for the Orvado Intranet. When designing the project, I did my best to try and keep things simple so development time would be short, but as these things tend to do, it ended up taking a lot longer than I thought.

The good thing is that it will be flexible enough to handle many different types of reports. Basically, a report is based on a series of SQL (database) statements that generate recordsets. These recordsets can be manipulated using a report template which will convert the data into a nice friendly human-readble format like HTML.

Most of the work has been creating a library to parse the macros in the report template. I’ve just about got a handle on it, but it still needs a little bit more work before I begin testing. The good news is: once that I’m done, I’ll have a nice framework for supporting macro substitution using template files which I can apply to lots of other projects.

This entry no have comments... but you can be first.

Leave a Reply

You must be logged in to post a comment.