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

9 posts, 0 answers
  1. Paul
    Paul avatar
    6 posts
    Member since:
    Feb 2012

    Posted 29 Mar 2012 Link to this post

     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 ]
    |
    |
    [ 
  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 02 Apr 2012 Link to this post

    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.
  3. Steven
    Steven avatar
    81 posts
    Member since:
    Dec 2011

    Posted 02 Apr 2013 Link to this post

    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.
  4. Elian
    Admin
    Elian avatar
    435 posts

    Posted 05 Apr 2013 Link to this post

    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.

  5. DXC
    DXC avatar
    1 posts
    Member since:
    Nov 2017

    Posted 18 Apr 2018 Link to this post

    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 ] 
    |                                        |
    |                                        |
    [    ]                                   [   ]

  6. Silviya
    Admin
    Silviya avatar
    330 posts

    Posted 20 Apr 2018 Link to this post

    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
  7. Karthi
    Karthi avatar
    2 posts
    Member since:
    Sep 2018

    Posted 11 Mar Link to this post

    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?

  8. Karthi
    Karthi avatar
    2 posts
    Member since:
    Sep 2018

    Posted 12 Mar in reply to Karthi Link to this post

    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 ?
  9. Silviya
    Admin
    Silviya avatar
    330 posts

    Posted 14 Mar Link to this post

    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
Back to Top