Simple group totals where item being totaled is a variable.

edited October 2010 in End User
?I am a newbie at this. I have created a report where the last item on each
detail line is the extended value of an invoice and is calculated within the
report (variable3). There are 4 sorts and appropriate groups. Is there a
simple way to total variable 3 and print it at each group break.

--
Donald L. Joseph CMC
________________________________
President
Northbrook Consulting Group, Inc.
djoseph@northbrookconsulting.com
847-835-0979

Comments

  • edited October 2010
    Hi Donald,

    Since you are already making a calculation for Variable3 (hopefully in the
    OnCalc event), you can simply update another TppVariable's value that is
    inside the Group Footer.

    For instance (assuming Variable4 is located in the group footer).

    Variable3.OnCalc
    begin
    Value := Value + Report.Datapipeline['MyField'];
    Variable4.Value := Variable4.Value + Report.Datapipeline['MyField'];
    end;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2010
    ?I have not been using the OnCalc Event.. The statement I have been using
    is:
    Value := ReportData['ShipQty'] * ( ReportData['UnitPrice'] -
    ReportData['UnitDiscount'] )

    This gives the correct result fot the detail line item variable., but not
    the group totals. How should I be doing it?

    Don Joseph



  • edited October 2010
    This is a multi-part message in MIME format.
  • edited October 2010
    Hi Don,

    For future reference please send all attachments to
    support@digital-metaphors.com.

    I am not familiar with the ".rbu" file extension. Are you using a
    registered copy of ReportBuilder and Delphi or are you using ReportBuilder
    built into another application?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2010
    ?It's built into Sage BusinessWorks. I was wondering why I couldn't reload
    it . The application's report takes all data fields to come up with
    a net price per line item. I added an extension (Quantity shipped * net
    price) which prints the total for that line. But the records are sorted by
    product, by customer, by sales rep, and by product line, with an appropriate
    group for each sort. So if the extended price is Variable1, how are the
    corresponding subtotals calculated for the breaks?

    Do I have to repeat the calculation for Variable1 in each, with different
    "reset on" values? Or is there a way to refer to the value of Variable1?


    --
    Donald L. Joseph CMC
    ________________________________
    President
    Northbrook Consulting Group, Inc.
    djoseph@northbrookconsulting.com
    847-835-0979

  • edited October 2010
    -----------------------------------------
    Article: End-User Tech Support
    -----------------------------------------

    Please understand that Digital Metaphors can only provide tech support to
    the Delphi developers that purchase ReportBuilder. Digital Metaphors
    receives no distribution royalties from Delphi developers that embed
    end-user reporting solutions in their applications. It is the responsibility
    of the software publishers that sold you the product to provide you with
    tech support.

    There is an end-user tutorial called Learning ReportBuilder that can be
    downloaded from our web site for free. See the following article for more
    infomation.

    --------------------------------
    Article: Learning ReportBuilder
    --------------------------------

    Learning ReportBuilder is a complete learning system designed to teach end
    users how to build a range of reports. This system includes a 125-page PDF
    file, a stand-alone application complete with a database, and a help file.
    The PDF file is comprised of a series of tutorials that step end users
    through the process of building reports as simple as a table listing and as
    complex as crosstabs. The tutorials also introduce conceptual aspects of
    report building along the way. The application is used in conjunction with
    the tutorials so that the learning experience is interactive. The end user
    just prints out the PDF file, runs the application, and learns
    ReportBuilder. The help file is accessible from the application, so all
    three tools work together to provide a seamless learning environment.

    Learning ReportBuilder installs into C:\Program Files\LearnReportBuilder.
    When the system has successfully installed, a complete set of instructions
    appears in the form of a 'ReadMe' doc, so the end user knows just what to do
    upon installation.

    - Download Learning ReportBuilder

    http://www.digital-metaphors.com/LearnRB/LearnRB.exe

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.