SQL Query Mode

For SQL developers, you might want to generate the reports from SQL query script directly. DbFacePHP also provide a way to do this.

In the Report Builder page, you will find the “SQL Query” checkbox, check this checkbox, DbFacePHP will switch to SQL Query mode.

Build reports from SQL directly

Switch to SQL query mode

Note: If you already do some drag & drop before switching, DbFacePHP will try to generate a script to initialize the SQL query editor. Many people like this feature.

Create chart report from SQL script directly with DbFacePHP

Create chart report from SQL script directly with DbFacePHP