Number Report

DbFacePHP provides “Number Report” to highlight single data value, like total payment of all the orders, total customers in a quarter.

Create Number Report with DbFacePHP

Create Number Report with DbFacePHP

Create Number Report

To create a Number Report in DbFacePHP.

  • Select Number Report type
    Select Number Report Type In DbFacePHP

    Select Number Report Type In DbFacePHP

  • 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.)

    Build Number Report in DbFacePHP

    Build Number Report in DbFacePHP

  • Done
    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.