Tutorial: Field grouping

In this example, we are going to develop a report using the grouping of fields in a single column for a better visualization of the data.

Creating a new Grid

1. We will create a new Query application

2. Then we will include a custom SQL code in the “Select Command”.

SELECT

Warrants,ord.customerid, employeeid, orderdate, requireddate, shippeddate, shipvia, freight, priceorder, shipcountry, shipregion, shipstate, shipcity, shipname, shipaddress, shippostalcode, companyname, contactname, contacttitle, country, regions, states, city, address, postalcode

FROM

orders ord

INNER JOIN

customers cust ON cust.customerid = ord.customerid

WHERE

ord.orderid NOT IN (11087, 10395)

ORDER BY

orderdate DESC

Formatting the Grid layout

1. In the application menu, access the option Fields and click on the item new field

2. Let’s create 4 groupings of Fields: order, contact, ship_info and ship_address.

order

contact

ship_info

ship_address

3. In the field “ord.priceorder” let’s configure the style of the column to differentiate from the others.

Tab “Display Settings”.

Let’s change the colors of the cells.

Result

4. In the “Field Positioning” menu, select to display the fields as shown in the image below.

5. Click “Run Application”.

Tutorials in the same category

Card View HTML

This tutorial demonstrates how to create a Grid application using the “User defined” ori...

Evaluation Field in the Grid

In this tutorial, you will see how to use the evaluation fields in a Grid application. We ...

Evaluation Field in Summary

In this tutorial, you will see how to create a Summary by using the evaluation fields. We can use ...

Grid with fixed toolbar

In this example, we are going to develop a report using a fixed toolbar on the top so we can...