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

How to do a sub total when page break

7 Answers 416 Views

General Discussions

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

Alex asked on 20 May 2009, 09:37 AM

Hello,
I am a new user on Telerik reporting in demo for now.
I try to realize to insert in my report a line at the end of page and at the beginning of the page who make a sub total of an group who is not ended on a page.
My report is like this :
Page Header
Report Header
    First group title
    columns titles
            Detail lines
        Second group  totals
    First group totals
Report Footer
Page Footer
When a page breaking the second group, I want this
    detail lines
    sub total line of the second group (sum of the lines before in the group)
page footer
page header
    First group header
    columns title
    sub total line of the second group (sum of the lines before in the group)
    detail lines

I tried this :
Page Header
Report Header
Group 1 (grouping on a string field)
    Header group 1                     whit the string field
    Group 2 ( no grouping)
        Header group 2 with my columns header
            Group 3 (grouping on a date field with no header)
                    Group 4 (no grouping)
                        Header group 4 (PrintOnEveryPage = true) contains a sub total by programming -> I want this visible only if a page break occurs
                            Detail     contains a total of the precedent lines
                        Footer group 4 (PrintOnEveryPage = true) contains a sub total by programming -> I want this visible only if a page break occurs
                Footer group 3   contains a sub total of all lines of the group 3
    Footer Group 1 contains a sub total of all lines of the group 1
Page Footer

two problems occurs :
    - I don't see a function which can do the sum of only the detail lines before the page footer
    - I can't render visible or not the group Header / Footer 2 because I don't know the reaon why it appears

Is this an issue of my problems ?
Is it a better way to do this ?

7 Answers, 1 is accepted

answered on 20 May 2009, 10:55 AM

Hi Alex,

Thank you for contacting us and your interest in Telerik Reporting.
Please note that page breaks in reports are per section only i.e. you cannot have a pagebreak somewhere in a section.
If you want to calculate Grand Total, place the TextBox in the ReportFooter section. Please take a look at "Understanding Report Sections" help article to clarify why it is not correct to use data fields in Page Header/Footer sections.
As you can see from the above article, the report header/footer and group header/footer sections work with aggregated functions and if no aggregate is specified by default, it would use First. So you can use SUM() aggregate in the group footer/header without problems and it would calculate the sum for the detail records.
As for hiding a group footer/header, you can use similar code:

    
             private void labelsGroupFooter_ItemDataBound(object sender, EventArgs e) 
        
                    { 
        
                        Telerik.Reporting.Processing.ReportSection footerSection = (Telerik.Reporting.Processing.ReportSection)sender; 
        
                        Telerik.Reporting.Processing.TextBox groupTotal = (Telerik.Reporting.Processing.TextBox)footerSection.ChildElements.Find("groupTotal", true)[0]; 
        
                        if (your condition here .. e.g. use groupTotal.Value) 
        
                        { 
        
                            footerSection.Visible = false; 
        
                        }  
        
                    }

Hope this helps.

Sincerely yours,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.