Creating a tabular report

Updated 1 month ago by Kiruthika

Tabular reports can be used to display your data in rows and columns forming a grid similar to a spreadsheet.

Creating a tabular report

  1. To create a tabular report, click Reports in the upper-right corner of the process page. 
  2. Click +Create report and choose Tabular report.
  3. Provide a name for the report and click Create.

Configuring the report

You can configure your report by choosing the fields to be displayed, applying filters, and sorting the field values accordingly. 

Under Columns, you can choose the fields that have to be displayed in the report. There are three types of fields you get to choose from this dropdown:

  • Process fields - The new fields created exclusively for your process using the form builder
  • System fields - The predefined fields that are common and available across all the processes in Kissflow
    • Name - The item’s name
    • Created by - The user who created the item
    • Modified by - The user who modified the item recently
    • Created at - The time at which the item was created
    • Modified at - The time at which the form was last modified
    • Flow name - The name of the flow
    • Current step - The step the item is currently in
    • Currently assigned to - The user currently assigned to the step; this field will be empty if the workflow is completed
    • Status - The status of the item
  • Workflow fields - These are the steps you created in your workflow. The field will display when a step was completed, who completed it, the current status, and if the deadline was crossed. 
You can choose any number of fields from the Columns dropdown for your report. You will see a sample set of 10 items in the report preview.

Column width, ordering

Resize the column width by placing the cursor on the edge of the column and then dragging it to the length you want. You can also drag and drop the fields to reorder them.

Applying filters

You can add filters based on a condition in your report.

  1. Click the Add advanced filter button under the Filters section
  2. Click the +Add a filter button
  3. Select the field you want to filter from the Select field dropdown
  4. Choose a relevant operator that matches your condition and the selected field from the Operator dropdown
  5. Select a relevant value or field to compare the chosen report field with.
  6. Click the Add a condition link to create as many conditions as you want.
    1. The AND operator checks whether all the given conditions are met
    2. The OR operator checks whether at least one condition is met
  7. Click +Add new filter to add conditions for another field. Repeat the same steps you just followed to set the filter criteria of a report field above.
  8. Click Apply to view the results of the filter(s) you created.

The results must match all the filters you created. Click the ‘close’ icon to delete a filter and the ‘minus’ symbol to remove a specific condition from your filter.

Sorting

You can set the default sorting of your report. 

  1. Select a field based on which the data in the report has to be sorted
  2. Select Ascending or Descending based on your preference
  3. Click Save


How did we do?