Help with calculated field totaling

Posted by: ggrady on 4 August 2017, 2:54 pm EST

  • Posted 4 August 2017, 2:54 pm EST

    Hi;


    I have a calculated field in my groupfooter. 


    I make the calculation in the on before print .


    I need to present a total of those values in the report footer, how is the best way to do this.


    TIA


     

  • Replied 4 August 2017, 2:54 pm EST

    You'll want to use an unbound datafield behind the scenes with the data you need to calculate. Here's a KB article on the process:

    http://www.datadynamics.com/forums/424/ShowPost.aspx
  • Replied 4 August 2017, 2:54 pm EST

    Hi Brandon;


    The article didn't solve my issue.


    I have a field in a group footer.


    somefield.datavalue = (grouptotal.datavalue/reporttotal.datavalue)* SomeVariable


    I do the calcuation in the before_Print event of the group footer.


    I need the total of those values.  Each group footer has a total.  I need to total them all up and present them in the report footer.


    There may be a better way to do that calculation.  I have no detail on my report, it's all in the group header and footer.


    I can't do the calculation in the fetchdata because the calculation is on the grouptotal and report total which are not available at the time the data is fetched. 


     


    Regards,


    Gracie

  • Replied 4 August 2017, 2:54 pm EST

    The calculation must either be done in your datasource before assigning it to the report or it must be done with an unbound field or fields in the FetchData event. There isn't a way to transfer that information reliably between the GroupFooter and the ReportFooter.
  • Replied 4 August 2017, 2:54 pm EST

    He could also use a module variable to total in the GroupFooter then in the ReportEnd event use the DrawText method to draw in the final total amount.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels