Tabular Report (Table View Report) displays the data in rows and columns, which is the easiest way to show the data. We offer many different options to customize how they appear.

Use a tabular report when you want to see the data in rows and columns.

You can also attach a Form to the tabular report.

Sample tabular report in DbFace

Table format accepted#

The tabular report accepts an unlimited number of measures and dimensions.No formatting restrictions.

Column 1Column 2Column 3...
Row 1 Row 1 Row 1 ...
Row 2 Row 2 Row 2 ...
Row 3 Row 3 Row 3 ...
... ... ... ...

Interactive Mode#

STEP 1: choose "Tabular Report" in "Visualization" section#

Sample tabular report in DbFace

STEP 2: Select or Join tables to make data sources#

Select a table or join tables to make tabular data source. Sample tabular report in DbFace

STEP 3: Drag Select Columns from Field List#

Sample tabular report in DbFace

  • Select Columns:
    The tabular report header titles
  • Order Columns:
    The default order conditions, this field is optional.
  • Label Column:
    You can click the field to label the column.

Label the column

  • Make Custom Column
    Click the dropdown of a column, and select "Custom" to make custom column.

STEP 4: Apply filter conditions#

You can also use form variables or global parameters in filter condition, e.g. if the tabular has a form that contains a input field that named status, you can use {$status} value in the filter condition. Sample tabular report in DbFace

STEP 5: Preview the tabular report#

Click "Preview" button to preview the tabular report, if there are errors, you need to correct them, and preview again.

STEP 6: Save the tabular report#

Click "Publish" button to publish the tabular report. Click "Draft" button to save the current tabular report and you can edit later.

SQL Mode#

Script mode provides you more flexible way to build tabular report.

Check the "SQL Mode" checkbox to switch to Code mode to build tabular report. DbFace will try to generate correct SQL query from the Report builder, but you still need to check the SQL query.

Here is a sample tabular report script:

SELECT
  `licensecode`,
  `clientcode`,
  `email`,
  `version`,
  `ip`,
  `httprefer`,
  min(`date`) as FirstVisit,
  max(`date`) as lastvisit
FROM
  `dbfacephp_license`
WHERE
  licensecode != ''
GROUP BY
  licensecode

Tips & Tricks

You can find more tips and tricks for tabular report at our knowledge base.

Tabular Options#

DbFace provides several options to help you custom the table report appearance. Table report options

Table Header#

Table header options

Series Settings#

The "Series Settings" tab offers multiple options for controlling the values in the table cells as well as the width of the columns and the text alignment. The tab should look like the following: Table report series settings

Format Dropdown#

The Format Dropdown Tab has 3 options: Number, Percent, and Currency. These can be selected to alter the numeric values in the table accordingly.

Currency Field#

If the "Format" field is set to Currency, the currently supported types of currency become available in its dropdown.

Decimals Field#

The Decimal field controls how many decimal places are displayed for a numeric value in the table. It is a useful tool for rounding values, and works with all types of Formats.

Width#

The width of the table columns can be manually adjusted by entering in integer pixel values. The default is set to "Auto", which determines the width based on the table data.

Alignment#

Alignment controls where the text falls in the cell. There are three options available: Left, Center, and Right.

Total Column#

The "Show Total Columns" option will only be available to numeric columns, and adds a row to the bottom of the table. This row will show the sum of all cell values for the columns that have this option enabled.

Conditional Formatting#

Conditional Formatting can be used to highlight a particular cell or cells within one column that matches the specifications.

To use conditional formatting, first select a column and click the cog icon button at the Series Setting pane,
Table report series settings and finally pick an appropriate threshold value. Only static threshold values are supported.
Pick approriate condition