Design and run reports
Embed reports within web pages.
Create a simple report using the designer front end in seconds from a single SQL statement. Add expressions, user criteria, charts, groups, aggregations, page headers, page footers, hyperlinks and even custom plugin code.
Create in code a builder query, set the formatting, expression, paging and embed in your page ...
\Reportico\Engine\Builder::build()
->datasource()->database("mysql:host=localhost; dbname=db")
->user("USER")->password("PASSWORD")
->title ("Employees Grouped By Country")
->sql ("SELECT employee_id code, name, country FROM employees")
->group ("country")->customHeader("Employees in {country}")
->page()->paginate()->size("A4")
->execute();
Click for Documentation
Design and run reports as administrator
Embed reports in Joomla! web pages.
Create links to reports within web pages
Use the Laravel Reportico package to design reports, create links and embed reports in your Laravel web application.
Use the Yii Reportico controller to design reports, create links and embed reports in your Yii web application.