If the other report types not work for you. You can define your own reports by PHP coding.
PHP Application only available on On-premise installation or Enterprise plan.
If you want to disable this application type, you can open config/config.inc.php and set disable_phpreport entry to FALSE.
DbFace's PHP development environment is based on CodeIgniter Framework, so you can benefit from all CodeIgniter features especially the Database Active Record.
You can get more information from CodeIgniter Documentation.
Build PHP Application#
Sign in DbFace with Administrator or Developer account. Click the "PHP Application" button in the "Visualization" section. DbFace workspace will show you PHP code editor.
Input your PHP code, and press CTRL + Enter or click Preview button to preview the PHP application.