Wise Use of Grouping Adjacent Identical Values

The main reason to use Grouping Adjacent Identical Values is to improve the performance of reports.

The operation of grouping adjacent identical values merges the same data that are sequentially sorted in a dataset. Adjacent identical values grouping performs better than common grouping, especially when you want to group columns that have been ordered in SQL,

Check the report calculation time as shown in the following simple example. The calculation time of adjacent identical values grouping is noticeably less than that of common grouping.

Dataset Creation

Create a dataset named ds1, and the SQL statement is as follows:

SELECT Classno,StudentNO,Name,Sex,Course,Grade FROM STSCORE order by Grade,Classno ASC

Table Design

Design the report, and drag fields into the corresponding cells, as shown in the following figure.

Grouping Setting

Common Grouping Setting:

Select cell A2, and then select Common for Data Setting. Preview the report, and check Log. The following figure shows the data information for report execution.

Adjacent Grouping Setting:

Select cell A2, and then select Adjacent for Data Setting. Preview the report, and check Log. The following figure shows the data information for report execution.