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

2 column report, 2 groups - force full page break after group

8 Answers 575 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 29 Mar 2012, 04:19 PM
 I have a report that has two groups (Report Category, and Day). It also has 2 columns. 

The problem I'm having is that when I reach the end of all of the items in the Report Category group, I need to force a page break. I've set groupFooterSection1.PageBreak = After in the report. Instead of a page break I'm seeing the next group start in the second column of the report. I need it to start on a brand new page. 

What I'm seeing:

--------------- PAGE 1 ---------------------------
 Column 1                  Column 2
[Report Category 1 ]  [Report Category 2 ]
|
|
[


What I want is:

--------------- PAGE 1 ---------------------------
 Column 1                  Column 2
[Report Category 1 ]  
|
|
[ 

--------------- PAGE 2 ---------------------------
 Column 1                  Column 2
[Report Category 2 ]
|
|
[ 

8 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 02 Apr 2012, 01:39 PM
Hi Paul,

The detail section is printed once for every row in the data source similarly to a repeater and this happens vertically. The columns actually represent the separate pages of the report, which are treated as logical pages rendered on the same physical page. Columns are arranged from left to right, top to bottom, and are separated by white space between each, and data flow in the columns is top to bottom, left to right. If the report is divided into more than one column, each physical page is divided vertically into columns, each of which is considered a logical page. The easiest way to visualize this is imagining the columns in a newspaper.
That said, applying a PageBreak with the current implementation of multi-column layout will result in a new column and that is by design. We cannot offer a workaround at this time.

Greetings,
Steve
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
0
Steven
Top achievements
Rank 1
answered on 02 Apr 2013, 05:15 PM
Are they're any rendering events that can be hooked.

OnRenderingCalc(object sender, EventArgs e)
{
   if (calculatedPage % 2 == 0)
   {
        // logical column2, break again for logical column1 on the next page.
        myPanel.PageBreak = PageBreak.BeforeAndAfter;
        // or thisRender.ApplyPageBreak();
   }
}


In future releases will there be a means to enforce page break logic on physical vs logical page breaks (even if its not supported in the designer)

It would also be nice to apply multiple columns to just a panel or section, this way the section logic is contained and calculated within its own boundaries.

[ Full Content Here                    ]
[ column1]  [column2]  [column3]
[ More full content                     ]

I understand this can be done with MODS (a KB article would be nice on this subject), but the tricky part comes with calculating what will fit on the page.



Thanks.
You guys are doing a great job.
0
Elian
Telerik team
answered on 05 Apr 2013, 01:28 PM
Hi Steven,

Thank you for your feedback and suggestions. We appreciate your involvement and value your opinion. 
Here are our thoughts on the topics that you have mentioned:

There aren't any rendering events and they should not be needed. The purpose of the rendering is to take a processed report and visualize it in a concrete format. There are a lot of different medias that we support and each one has its own peculiarities. We do not believe that exposing rendering events is the right thing to do as changes should not appear at that state of the report's life cycle.

Currently the only page breaks supported are the section page breaks. We have considered the ability to force a mid-section page breaks on demand but it is not currently in our near future plans as we believe that a meaningful report layout can be achieved without having such functionality. Of course you can always use a couple of static report groups and enable page breaks for their header/footer sections.

As to the multi-column items, you can use a Crosstab item for the purpose. If the items contained inside do not grow out of the design-time bounds and make the crosstab grow, then you should be able to easily calculate the space it will take up. If they grow, they will grow in height, so the width would still be predictable. And even if we did have a multi-column panel, it wouldn't be much different than what you can currently achieve with the Crosstab item. A similar idea is described in the Creating a Calendar Report with Telerik Reporting blog post.
 
Greetings,
Elian
the Telerik team

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

0
DXC
Top achievements
Rank 1
answered on 18 Apr 2018, 05:02 AM

We are converting an existing Crystal report to Telerik and facing the below issues with Telerik in the multicolumn report.

We want to display the group header based on grouping and split only the detail section to multiple columns and do page break after each group. Below is the illustration of report layout what we are expecting. 


What I want is:

--------------- PAGE 1 ---------------------------
------------------------------------------------------
              Group Header 1
------------------------------------------------------
 Column 1                  Column 2
[Group 1 Category 1 ]      [Group 1 Category 11 ] 
|                                        |
|                                        |
[    ]                                   [   ]

--------------- PAGE 2 ---------------------------
------------------------------------------------------
              Group Header 2
------------------------------------------------------
 Column 1                  Column 2
[Group 2 Category 1 ]      [Group 2 Category 11 ] 
|                                        |
|                                        |
[    ]                                   [   ]

What I'm seeing:
--------------- PAGE 1 ---------------------------
------------------------------------------------------
  Group Header 1           Group Header 2
------------------------------------------------------
 Column 1                        Column 2
[Group 1 Category 1 ]      [Group 2 Category 1 ] 
|                                        |
|                                        |
[    ]                                   [   ]

0
Silviya
Telerik team
answered on 20 Apr 2018, 03:33 PM
Hi DXC,

As my colleague Steve said, the multi-column report by design have this rendering behavior (from left to right, top to bottom) and applying a PageBreak property at the end of each group will result in a new column, not a new page. Also, the group header section is also a part of this multi-column layout, so it would remain the same width (in your case of 2 column report, it will take only the half of the page). 

Based on the provided information and example, this layout could be achieved with List item and indexed data starting from across the page and then down. For more information and example, check the How to: Create Multi-Column Report - Across the Page and Then Down KB article.
Then you could set PageBreak for each group to render on a new page.

In case of difficulties, please open a new support ticket and attach a sample report definition which we can investigate further and provide you more accurate suggestions.

Regards,
Silviya
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
0
Karthi
Top achievements
Rank 1
answered on 12 Mar 2019, 03:11 AM

I am struggling with checking Multi-column report too in a standalone report

I have this structure: 2 columns need to split into 4 

[Header][Header]

AAAA     123

BBBB     123

CCCC    234

DDDD    123

 

What I want is, in the same page (there will be always 1 physical page only)

[HEADER][HEADER]          [HEADER][HEADER]

AAAA         123                    BBBB          123

CCCC         234                    DDDD         123

 

Went through https://docs.telerik.com/reporting/advanced-creating-multi-column-reports but not able to generate. I am using a table inside the report to display the two columns above. Are you able to help please?

0
Karthi
Top achievements
Rank 1
answered on 13 Mar 2019, 04:18 AM
I figured this one out as I was setting data source at the report level instead of table. But interestingly that raises another question , suppose I need to always have 3 columns, how do I evenly distribute the data across the 3 columns (if i get 11 for example, I need to have 4,4,3 in columns 1,2 and 2 respectively) , is this possible ?
0
Silviya
Telerik team
answered on 14 Mar 2019, 04:01 PM
Hi Karthi,

Due to the data-driven nature of Telerik Reporting, this can be easily achieved with our Table/Crosstab/List item and indexed data as demonstrated in the attached report. The items are starting from index 1 to 11 and they are rendered in three columns with 4, 4, and 3 items.

Regards,
Silviya
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
Paul
Top achievements
Rank 1
Answers by
Steve
Telerik team
Steven
Top achievements
Rank 1
Elian
Telerik team
DXC
Top achievements
Rank 1
Silviya
Telerik team
Karthi
Top achievements
Rank 1
Share this question
or