Cross tab with large number of table column groups

[William]

Hi:

 I am working with cross tab now and was wondering if it is possible to split the data up into two portions e.g

Suppose I have the following data:

 Test, Unit, Value, Date

and will convert into a cross tab table like this:

Test,Unit,    1/3/2015, 2/3/2015, 3/3/2015, 4/3/2015, 5/3/2015, 6/3/2015, 7/3/2015,…
LDL,mg/dl,  4.2,         5.4,           4.5,          4.8,         4.7,           5.3,        5.6
HDL,mg/dl, 3.2,         3.1,           2.8,          3.5,          3.2,                ,        4.6
TRI,mg/dl,  5.1,         5.4,           4.9,          5.1,          4.8,           3.1,        4.7

 

but since the table column group could grow much larger, I was wondering if it is possible to split it into multiple parts, limiting each 'Group' to for 4 (as an example) date per group 

e.g

Test,Unit,    1/3/2015, 2/3/2015, 3/3/2015, 4/3/2015
LDL,mg/dl,  4.2,         5.4,           4.5,          4.8,        
HDL,mg/dl, 3.2,         3.1,           2.8,          3.5,        
TRI,mg/dl,  5.1,         5.4,           4.9,          5.1,        

 

Test,Unit,    5/3/2015, 6/3/2015, 7/3/2015,…
LDL,mg/dl,  4.7,           5.3,        5.6
HDL,mg/dl, 3.2,                ,        4.6
TRI,mg/dl,   4.8,           3.1,        4.7
​​

Many thanks

 Regards

 William

                          

 

 

[Nasko]

Hello William,

You will need to split the data from the data source and create two separate Crosstab items with different data sources to achieve the described layout. It is not possible to split the current crosstab on multiple rows.

Regards,
Nasko
Telerik

[William]

Hi Nasko:

 Thanks for the info, but if I don't have the exact number of items (in this case date), how should it be organized in the designer view?

 Many thanks

 Regards

 William

 

[Nasko]

Hello William,

It is not possible without knowing the number of items beforehand. In this case, it will be required to retrieve the data and count the items, then creating or modifying the crosstab definition.

Another option is to rotate the crosstab layout, so it fits the page width.

Regards,
Nasko
Telerik

[William]

Thanks, I guess this is all we can do for now.