Multi Column DetailsSection with full with header/footer

[Steven]

http://www.telerik.com/help/reporting/advanced-creating-multi-column-reports.html

I know that the PageHeader/PageFooter becomes calculations of the Page  margins, but is it possible to have multiple columns DetailSection with a full width section in the ReportHeader/ReportFooter

I have a group header that needs to change with the group s at the header and I have footer comments that need to span the entire width.

Can this be tweeked within the ItemDataBinding/Bound event to change the adjust the section width.

Thanks
Steve

[Steve]

Hello Steve,

The built-in multi-column functionality in Telerik Reporting that you refer to cannot be tweaked to work as you need. However you can achieve the desired layout with some manual preparation of the data and our agile CrossTab item.

1. Bind the report to your data source.
2. Add report groups as needed.
3. Place a CrossTab in the most inner group header and hide the detail section (Visible=false). Set the report data source as DataSource for the CrossTab item by add Binding with path "DataSource" and Value "=ReportItem.Parent.DataObject". This will feed the CrossTab at runtime with the correct data for the current group instance only. For the sake of the design time, you can set the DataSource of the CrossTab to the same DataSource as the report, this would allow you to drag and drop fields and have the fields available in the Expression Editor when specifying grouping/filtering/sorting etc.
4. Now the grouping of the CrossTab - 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, ....)

All the best,
Steve
the Telerik team

[Steven]

Will using the cross table wrap my content on the same page or just create two columns of equal objects (row count)


Current Design
=========================
Columns=2
[PageHeader]
[DetailSection]  
  [Table] with 3 static columns and 16 rows with grouping
[PageFooter]



Your Proposed Design
=========================
[PageHeader]
[Group1] = Static
   [Group2]
        [CrossTable]
        // My Table nested within the cross table?
   [DetailSection] = Hidden
   [Group2 - footer] = Hidden
[Group1 - footer]
    // Full Spanned Comments Footer
[PageFooter]




Desired End Result
=========================   
[Page 1]
TitleA $ $ TitleE $ $
TitleB $ $ TitleF $ $
TitleC $ $ TitleG $ $
TitleD $ $ TitleH $ $

[Page2]
TitleI $ $ TitleM $ $
TitleJ $ $ TitleN $ $
TitleK $ $
TitleL $ $

[Page3]
Full Comment Span Here



It should be pretty easy to implement, PageBreak = Optional Full Width, but the pageBreak elliminates the need to include it when calculating columns of the previous page.

[Elian]

Hi Steve,

The layout depends on how you setup the crosstab. If you set it up across then down, it will be like
1 2
3 4
5 
(fixed number of columns)

If you set it down the across
1 4
2 5
3
(fixed number of rows)

The Report grouping will help you to feed limited amount of data into each crosstab and start each crosstab on a new page.

For convenience, a sample project is attached. 
 
Regards,
Elian
the Telerik team

[Steven]

Can you provide an example that goes DOWN then ACROSS that spans multiple pages while keeping the top half of the items on Page1 Column1 and Column2 rather then in Page1 Column1 and Page2 Column1?

In the example I provided there are sectional totals, so I don't have a given height to calculate page splits as defined in your example
"Group = Fields.ID / 10"

I could predetermine these group totals before hand so that my table grouping is simplified if that is the only solution.
 

Desired End Result
=========================   
[Page 1]
TitleA $ $ TitleF $ $
TitleB $ $   TitleG $ $
Total $ $ TitleH $ $
SectionHeader TitleI $ $
TitleC $ $ Total  $ $
TitleD $ $
TitleE $ $ SectionHeader
TitleE $ $  TitleJ $ $
========= Page Break======
[Page2]
TitleK $ $ TitleR $ $
TitleL $ $ TitleS $ $
TitleM $ $   Total $ $
TitleN $ $ Grand $ $
TitleO $ $
TitleP $ $
TitleQ $ $
=========Page Break ======

[Elian]

Hi Steve,

You can add additional grouping to the crosstab (as a parent group to the current row group) which can group the items (again in a predetermined amount). In this case if you say that you will have 10 items per group in 5 rows (and 2 cols), you will get the following layout
1 6
2 7
3 8
4 9
5 10
---- (there may not be a delimiter here)
11
12
...

Sample project attached.
 
Kind regards,
Elian
the Telerik team

[Steven]

Wow,

Thanks for the info.
The mods are a bit hard to follow, but I can play around with them in LinqPad to see what I can create.


Thanks

[Mark]

Steven, did you ever get this to work for you.  Today, 5 years later, we are having this issue. I am supprised that .  We need full headers/footers, but also need 3 columns, Down then Across.  The example that was given above will not work, since it has a fixed number of ROWS, where on our first page, it might have 20 to 30 rows (based on data we might put in the Report header but on all other pages it might be 30 rows, again depending on what's int he page and report header bands 

[Todor]

Hi Mark,

I noticed that you have posted the issue in another forum thread (Multi-Column report generating only one column), where I have already responded.

Regards,
Todor
Progress Telerik