This is a migrated thread and some comments may be shown as answers.

Multi Column DetailsSection with full with header/footer

8 Answers 282 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 15 Jan 2013, 01:45 PM
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

8 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 16 Jan 2013, 11:48 AM
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

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Steven
Top achievements
Rank 1
answered on 22 Feb 2013, 06:30 PM
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.

0
Elian
Telerik team
answered on 27 Feb 2013, 04:29 PM
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

(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

See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

0
Steven
Top achievements
Rank 1
answered on 27 Feb 2013, 08:37 PM
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 ======
0
Elian
Telerik team
answered on 28 Feb 2013, 02:23 PM
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

See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

0
Steven
Top achievements
Rank 1
answered on 01 Mar 2013, 02:45 PM
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
0
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
answered on 13 Sep 2018, 03:37 PM
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 
0
Todor
Telerik team
answered on 18 Sep 2018, 11:37 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Steven
Top achievements
Rank 1
Answers by
Steve
Telerik team
Steven
Top achievements
Rank 1
Elian
Telerik team
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Todor
Telerik team
Share this question
or