Aggregate functions in section report group

Aggregate functions in section report group

Posted by: ekershaw on 23 October 2017, 1:44 pm EST

• 

  ekershaw

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 October 2017, 1:44 pm EST

  Similar to https://www.grapecity.com/en/forums/ar-dev/aggregate-formulas-in-sect, I am unable to get aggregate functions to work within a group footer. I am in a VB.Net solution, report language is set to VB.Net.

  What would the syntax look like if I wanted a calculation of the difference of two sums such as Sum(A)-Sum(B) inside the footer of a group identified by “GroupHeader1” that points to “FieldC” as its datafield (for grouping)?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 October 2017, 11:30 am EST

  Hello,

  You can set the formula in report’s FetchData event as per your requirement. I would suggest you to please take a look at the sample application attached to know more how you can apply formula in group footer.

  Thanks,
  
  Deepak SharmaCalculatedFields.zip