Create pages with access to a report menu, where each report allows data driven criteria entry and report generation in HTML, PDF and CVS formats. Create articles and embed report output in them or chain the output of multiple reports together in a single page.
Reportico supports groups, charts and complex custom expressions by including PHP code within report definitions.
Create a simple report with a single SQL statement and then get more complex with the addition of expressions, styling options and custom SQLs statements and custom PHP code which can manipulate and filter report data prior to rpeort generation.
Note that Reportico uses PDO for data access and requires this facility to be installed.