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 ( 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 the “Add calculated value” button to compose new values based on your data source. If you want to change aggregation for some field in the 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.

Learn more