Groups

Stardraw Design 7.4 Help

Click here to see this page in full context

Groups

You can use groups to organize data in your reports. The most common grouping scenario is to create groups by fields or expressions in a data region, for example, to arrange products by the value of their System and/or Room attribute.
Depending on the data region you are working with, you can group data in the following ways:

In a Table or BandedList, you can add group header and footer rows. You can also set detail grouping in the Table data region.
In a List, you can set detail grouping.
In a Tablix, you can add columns and rows either dynamically or manually to group data.
In a Classic Chart, you can group data by categories or series.

Detail Grouping in List and Table Data Regions

Detail grouping is available in the List and Table data regions. It is useful when you do not want to repeat values within the details. For example, in a Table bound to the Products dataset, without detail grouping you will see as many rows as there are results in the dataset i.e. a row for each Product in the project.

In this example the Table has Sorting applied using =[Manufacturer] so the results are listed alphabetically by Manufacturer.

Table with Product Details at run time

Preview of a table without detail grouping

If you set detail grouping to:

=[Model Number]

each Model Number appears once.

In this example column 1 has the expression =Count([Model Number]) to show the quantity of results for the current row i.e. the number of each particular Model Number in the project.

Table with added detail grouping at preview

Table with detail grouping by Model Number

When detail grouping has been applied you can then use powerful aggregate functions like Count(), Sum() etc. for example, to show the quantity of each product, or the Sum of the price of all products with the same Model Number.