AUTHOR: Stephania Tapela
DATE MODIFIED : October 20, 2017
DATE POSTED: February 27, 2017
Article relates to
February 27, 2017
Last modified by
How to Create a Dynamic Table/Crosstab/List item.
In different scenarios data may not 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.
The idea is to create a data source describing the data in terms of columns, rows and content, which should result in a flatten tabular representation of data like:
Then you can add a Table/List/Crosstab item with dynamic row and column groups based on the columnName and rowIndex fields.
The attached demo report illustrates the settings. The report can be previewed in the Standalone Report Designer of Telerik Reporting R1 2017 and newer.