Repeating Data

[Sean]

Hello and thanks in advance,

I'm not exactly sure what to call what I am trying to acheive so I will provide a visible representation. I have a list with multiple items I need to display and I would like to know how to acheive the following format.

Business Object contents = (1,2,3,4,5,6,7,8,9,10,11,12,13)

Output format:

1                9
2                10  
3                11
4                12
5                13
6
7
8

[Steve]

Hi Sean,

You can accomplish such layout by utilizing the multi-column feature of Telerik Reporting, you can find more info about it in the Creating Multi-Column Reports help article.

Greetings,
Steve
the Telerik team

[Sean]

Hey Steve,

I went to the link you posted and tried to create a multi column reprot however I think it will not work because it is infact a subreport. Can you clarify that this is the case?

Thanks

[Steve]

Hi Sean,

The multi-column feature does not require the usage of subreport, do you mean that you use a subreport? If that is the case, then yes multi-column report used in subreport item would be rendered as one-column report.

In such scenario you can handle the multi-column layout with our CrossTab item. The idea is to do the CrossTab grouping by a criteria that will always return equal number of columns. This is accomplished by using "Id % X" and "Id / X" where X = number of columns and Id is consequential numbering (1, 2, 3, ....)

Greetings,
Steve
the Telerik team

[Sean]

Hi Steve,

Sorry for not being more clear, the report that requires the multiple columns is a subreport of a larger report. I will experiment with the crosstab control and see what I come up with.

Thanks Again

[Sean]

Hi Steve,

Do you think you could elaborate or provide me with and example of using the crosstab in this way?

Thanks

[Steve]

Hi Sean,

I've attached a simple project that shows how to use the suggested approach. Give it a spin and let me know if further help is needed.

Greetings,
Steve
the Telerik team

[Sean]

Hi Steve,

Thank you for the example , I am trying to do the opposite down then across.

1            9
2            10
3            11
4            12
5
6
7
8


So I switched the ID % 8 and ID / 8   from each grouping to the other. It almost works but it display like this instead of like above.

1            9
2           10
3           11
4           12
5
6
7
            8

It is unfortunate there is not a simple solution to this, your feedback and thoughts are greatly appreciated.

Thanks

[Hrisi]

Hi Sean,

Your subreport content should be rendered on one page only. If it is longer additional page will be generated as shown in the attached report.

Kind regards,
Hrisi
the Telerik team