Sub-total on each page

[wilson]

Hi,
  I checked few posts and looks like telerik reporting does not support sub-total on each page
  http://www.telerik.com/community/forums/reporting/telerik-reporting/sub-total-on-every-page.aspx
  http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-sum-fields-that-appear-on-a-single-page-and-display-it-in-the-same-page-s-pagefooter-section.aspx

  Both posts are from long time ago and I am wondering does telerik report support this function yet?

Thanks.

[Peter]

Hi Wilson,

With Q1 2011 we have introduced page totals (page aggregates). To add a page aggregate you need to use the PageExec function. It takes two parameters:

• itemName – determines which data objects are included in the page exec accumulation. For each instance of the report item with the specified name that occurs on the current page, its data object is accumulated.
• aggregateFunction – the aggregate that is accumulated for each page. The expression used as argument of the aggregate function is evaluated against the collected data objects.

For example the expression 
=PageExec("lineTotalTextBox",Sum(Fields.LineTotal))
used in a page section (page header or footer) will return the LineTotal summary for every single page of the report.

Give it a try and let us know how it goes.

All the best,

Peter
the Telerik team

[wilson]

Hi,
  Let's say I have LintTotal in my in my sql query, so all I need to do is put a TextBox in pageFooter, then add: =PageExec("lineTotalTextBox",Sum(Fields.LineTotal))

  What is "lineTotalTextBox"?  Is that the name of the TextBox i added into pageFooter?

   

[Peter]

Hi Wilson,

"lineTotalTextBox" is the textbox located in the Detail section/group and has Fields.LineTotal as expression. Check out the Invoice demo that came with your installation of Telerik Reporting for a PageExec() runnable example.

All the best,
Peter
the Telerik team

[wilson]

I created a textbox (textbox27) in the page footer section, with the following expression:

   =PageExec("TextBox32",Sum(Fields.ComponentTotalPrice))

Where, in the details section, "textbox32" is the line total.  I am trying to SUM the line total for each apge.  

But, when I run the report.. I get this error:

"An Error has occured while processing Textbox 'Textbox27':
The expression contains undefined function call PageExec()."

Please help....

[Steve]

Hi Wilson,

Did you upgrade to the Q1 2011 version where we introduced the page aggregate functionality? If so, you should see the PageExec function in the Edit Expression Dialog inside the Functions node.

Kind regards,
Steve
the Telerik team

[wilson]

Hi, actually, since the reply of the last post (about the undefined function) - I have already installed the latest latest Telerik Reporting.  So I was finally able to get the function to return a page total value.

However, I have discovered another problem (which I already created a support ticket).  

The behaviour is...  if there is any conditional formating in any object inside the pageFooter section - the pageExec won't calculate the sub-total.   It is a repeatable behavior.  

Let' assume there is only 2 objects inside the pagerFooter.   Both object have NO conditional formating.   Sub total will work and will calculate.   As soon as I put conditional formatiing in EITHER one of the object (textbox) - it will stop calculating....

If anyone know any workaround.  pls help....

Wilson

[Steve]

Hello Wilson,

We have verified the issue and can confirm that such a problem really exists and it is related to the PageCount global object (which triggers an extra paging pass). The issue is logged in our bug tracking system and will be fixed for the next official release or an internal build. We cannot offer a workaround for your scenario, as your conditional formatting depends on the PageCount object.

Please excuse us for the temporary inconvenience.

Best wishes,
Steve
the Telerik team

[Chetan]

I have assign column header name to one of the textbox say 'txtcolumnDetails'. then assign datatable(dtData) to report as follows
 report.DataSource = dtData;
this.ReportViewerObj.Report = report;

I have taken one textbox as 'txtPageTotal'  in footer section in which i have to show subtotal. To show sub total I have done like this

txtPageTotal.Value = "=PageExec(\"txtcolumnDetails\",Count(Fields.Fname))";

but it is not showing count .it giving result zero.How to show sub total please suggest me


Thanks in advance.

[Peter]

Hello Chetan,

We will need the report definition to debug on our end, without the report definition we can only guess what goes wrong. Please open a support thread and send us the problematic report.

Regards,
Peter
the Telerik team