how to design dates calender

[Mazen Bteddini]

hi,

i need to show dates calender grid/matrix in the report like
---------------------------------
jan       01 02 03 ... 31
Qty           7    2
Mar     01 02 03 ... 31
Qty       3       6
---------------------------------
so what is the best way to design that matrix consider that more rows might be required beside the Qty. i thought of doing that fully in the code-behind by formatting the matrix as html then include it in the detail section. please recommend the best flexible approach to design that?

thanks,

[Steve]

Hello Mazen Bteddini,

You can take advantage of the Crosstab report item for your scenario. In fact we have a similar example in our demo reports - the CrossTab demo report.

Greetings,
Steve
the Telerik team

[Mazen Bteddini]

Hi,

I tried the crossTab but didn't work with me? i need the column group of [Days of the month] to be repeated on every Row Group of [Month of the year] record. please advise how i can repeat a coulmn group???

thanks,