How to Create a Dynamic Table, Crosstab, or List Item

Environment

Product Version	R1 2017 and later
Product	Progress® Telerik® Reporting
Report Item	Table, Crosstab, List

Description

In different scenarios, data may not an have exact schema to be used for designing a report. In such cases, you can use the fact that the Table/List/Crosstab item can visualize 3D data.

Solution

The idea is to create a data source describing the data in terms of columns, rows and content, which should result in a flattened tabular representation of data like:

columnName,rowIndex,cellContent
column1,1,11
column2,1,21
column3,1,31
column1,2,12
column2,2,22
column3,2,32

Then, you can add a Table/List/Crosstab item with dynamic row and column groups based on the columnName and rowIndex fields.

Notes

• The attached demo report illustrates the settings. The report can be previewed in the Standalone Report Designer of Telerik Reporting R1 2017 and later.

• The scenarios, requiring you to create or modify a report at run-time, are discussed in Modifying or Creating a report at Run-Time.

Additional Resources

Download the sample report.

See Also

Basic Concepts

Understanding Crosstab Areas

Understanding table Cells, Rows and Columns