How to Create a Dynamic Table/Crosstab/List item

AUTHOR: Stephania Tapela

DATE MODIFIED : May 23, 2018

DATE POSTED: February 27, 2017

PROBLEM
How to Create a Dynamic Table/Crosstab/List item.

DESCRIPTION
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.

• Basic Concepts
• Understanding Crosstab Areas
• Understanding table Cells, Rows and Columns

SOLUTION

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.

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

Files