We will introduce Crosstab – Data Scale Out of FineReport reporting software in this article.Like grouped report, crosstab is another basic report type.The crosstab groups the data from up to bottom and from left and right.

1. Overview

Like grouped report, crosstab is another basic report type. The difference is in that, the grouped report only displays data by groups from up to bottom, and the crosstab groups the data from up to bottom and from left and right. As shown below:

FineReport supports row and column symmetry and it is simple to design a cross-tab.

2. Formation steps

2.1 Create a new workbook and add data set

Create a new workbook and add data set ds1 with SQL statement SELECT * FROM [Sales Volume].

2.2 Make crosstab

After sample table is designed, drag the data column to the corresponding cell.

Column header: Default the Region and Sales Staff as vertical scaling to realize up-to-bottom grouping;

Row header: Set the Product Type and Product as Scale Out for lateral grouping of Product to realize column header;

Data: Based on the concept of parent-child cell , the Sales Volume will take Sales Staff as the left parent cell and Product as the upper parent cell for automatic matching of the Sales Volume corresponding to the Sales Staff and the Product.

Preview to see the Crosstab as shown above.

Note: The Sales Volume corresponding to the Sales Staff and the Product is unique, so just drag Sales Volume to the cells.

In addition: If the Sales Volume corresponding to the Sales Staff and the Product is not unique, set the display mode of the data column Sales Volume as Summary- Sum. For details, refer to Data Display Mode.

2.3 Save and issue

For completed templates, refer to %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\CrossReport\Cross.cpt.

Click Cross.cpt. to check template effect online.

For the address of online video in the section of Crosstab, please refer to [Crosstab].