Reporting with Koolreport

[Patrick Pliessnig]

Hello

I tested Koolreport [1] for integrated reporting with SGS. It works very well.

Basically you can

a) define reports with Koolreport and

b) run them with a URL

c) integrate this URL as an asset in a portal folder of SGS

This way you can easily integrate charts (eg. Google Charts) and exports (eg. PDF, PNG, Excel) in your folder system within SGS.

For the reports to work out of the box, you need to install Koolreports on another domain. This way you can use the latest PHP version (version 5.4 and higher)

In case you want to use a subdomain, SGS might treat the URL as an internal URL and you need to modify the asset_portal.tpl template to avoid that 'iframe=1' is appended to the URL

[1] https://www.koolreport.com/

Cheers

Patrick

NB: Koolreports could effectively be integrated more deeply within SGS and would be able to replace some of its functionality. This would need developer's work.