A Report-Structuring Model for Database and Web Applications

Report generation is arguably the most important task for Web-based database applications, since dynamic Web pages consisting of database reports are essential to almost every transaction. When a report is generated, the layout of the data sources must be converted to the layout of the report. In this paper, we propose a report-structure tree to model the layout of nested reports. A series of tree nodes are used to define the structure of reports, produce nested results, and offer aggregation functions. We enhance our previous work (TPS) to support the design of report-structure trees visually. We show that sophisticated nested reports can be created easily