With WebDataRocks you can organize your data in various ways. This article explains how to define which data is shown on the grid. Each field can be selected to rows, columns, values or report filters.

To start fields configuration you will need the Field List ( menu_fields button in the Toolbar). It looks the following way:

Pay attention to the section All Fields on the left. It contains all fields from your data source. Drag these fields to the boxes on the right, such as Rows or Values.

Use “Add calculated value” button to compose new values based on your data source. If you want to change aggregation for some field in Values box, press the Edit button () next to its name.

After configuring fields the way you want, just press “APPLY” to see the changes on the grid.

How to show certain fields when loading data

  1. Configure your fields using the Field List
  2. Save your current configuration and apply it when setting new report (for more details see Saving and opening reports)

Want to check how is the fields configuration defined in the report? Find slice section in our online demo.