DbFacePHP provides “Number Report” to highlight single data value, like total payment of all the orders, total customers in a quarter.
Create Number Report
To create a Number Report in DbFacePHP.
- Select Number Report type
- Drag One Column to Select Column
Drag one column that you want to highlight to the “Select Columns” field, and choose the aggregate function (sum, count, etc.)
You just build a Number Report
You can also build Number Report from SQL query script directly. DbFacePHP will take only the first column value as the highlighted value.