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.