Need Help with Multiple Columns Issue!

[Mohammed]

Is there any way to achieve the following report?

The report should have the following:
1. a header that should show up only on the first page, and it should extend over the complete width of the page (i.e.. it will cover both columns in the detail section below).
2. a detail section with 2 columns.

I tried the following but did not work:
1. page header, since I can not restrict it to the first page only.
2. report header and group header, both will follow the 2 columns structure and will not extend over the complete page width.

Any help will be appreciated, thanks.

[Steve]

Hello Mohammed,

This behavior of the multi-column feature is by design i.e. page header and footer are not related to the report itself, but are relative to the margins of the report's media and that is why they occupy the entire page width, while the report sections stick with the detail and multiply as it does.

You can handle such scenario with some manual preparation of the data and the CrossTab item. The idea is to do the CrossTab grouping by a criteria that will always return equal number of columns (the desired 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, ....). By using this approach you can have the CrossTab in a report section and utilize a report header as initially intended.

Kind regards,
Steve
the Telerik team

[Nate]

We are having this same issue. The Crosstab table you explained doesn't make sense to us. Can you explain it a little more step by step, or provide an example project? That would be most helpful!

Thanks,
Nate

[Steve]

Hello Nate,

I've attached a sample project that utilizes the approach I've described in my previous post. Give it a spin and let me know if further help is needed.

All the best,
Steve
the Telerik team

[Nate]

Thank you for the example. That helped me see your explanation.