Fix number of columns in Crosstab

[L]

hi

is it possible to have a fix number of columns display in a crosstab?

I want to display 5 columns regardless of how many dates I have.

For example, our business day starts on Monday ends on Friday.

Lets presume, there are 20 business days per month and Monday is on 1st of February.

and today date is 10th February, my crosstab report would have 2 pages of 5 columns each

The first page would display 5 columns from 1st to 5th February, and the second page would display 8th to 10th February and 2 empty columns.

Is it possible? Thanks a lot

[Nasko]

Hello L,

Instead of Crosstab, you can use a Table item, which has a fixed number of columns.
You may also need to reorganize your data in a way that allows a single data row to contain data for five days. This will allow you to place the Table item in the detail section and use an expression to feed the Table with data from the current data row. Then you can set the PageBreak property of the detail section as required so each Table can start in a new page.

Regards,
Nasko
Telerik

[sandaruwan]

tnx Nasko's