Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

var missing last value

edited May 2005 in General
I have a tppVar in a summary band of a report with 2 subreports. The var is
calculated in the oncalc event of one of the subreports vars:

procedure TReptSF.ppVarMTCostCalc(Sender: TObject; var Value: Variant);
begin
Value := Value + dm.ATRpAdCostTotCost.Value;
pplMCost.Caption := formatFloat('##,###,##0.00',Value);
ppVarTotalCost.Value := ppVarTotalCost.Value + dm.ATRpAdCostTotCost.Value;
end;

It calculates correctly upto the last subreport - the value is correct
except for the last section. This seemed to have worked in 7.0. I just
upgraded to 9.02. I am using Delphi 6.

Thanks,

Matt

Comments

  • edited May 2005
    if you can put together a small demo and send it to them.

    --
    Ed Dressel
    Team DM
  • edited May 2005
    It is a very big report, there is no way to "put together a small demo".

    Is there noone else who had a problem like this?

    Thank you,

    Matt
  • edited May 2005
    Hi Matt,

    There is a patch available that should solve this issue. Please send a
    small email requesting this patch to support@digital-metaphors.com and we'll
    send it to you as soon as possible.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2005
    Thank you, I look forward to getting this.

    Matthew
  • edited May 2005
    I downloaded the patch, copied it to the c:\program
    files\borland\delphi6\Rbuilder\Lib, renamed the existing ppvar.dcu and
    recompiled the project . It created a ppvar.dcu dated today. I am still
    getting the same results - the total on the summary is does not include the
    final group. Please help. This is a project in production and my client
    needs this report.

    Thank you,

    Matthew
  • edited May 2005
    Hi Matt,

    I apoligise for the mistake, this must be a different issue however we have
    not had any reports of this behavior nor am I able to recreate it myself
    with RB 9.02. If you trace into the OnCalc event, is the code even firing
    for the last subreport? Perhaps a better explaination of how your report is
    designed will help me understand what is happening. If this is a bug in
    ReportBuilder, I will need to recreate this bahavior on my machine. If
    possible please construct a simple application (perhaps using the DBDEMOS
    database) that demonstrates the behavior you are experiencing and send it in
    .zip format to support@digital-metaphors.com.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2005
    Nico,

    I have tried to recreate this problem using dbdemos but the report has many
    details in it. However, when I look at the Tutorials Complete applications
    demo Report Launcher "interactive previewing with drill-down subreports",
    your totals also have a problem.

    I do not know if this is related but as I also have a drill down component I
    would like you to look at this. Take any order and drill down. You will
    see that the first line item is not included in the detail total

    i.e. Kauai Dive Shoppe, Cust 1221 order 1023 shows on the summary a total of
    $4674.00. If you drill down, the first item of $1250 is not in the total in
    the details which shows 3,424.00. This is consistant throughout this demo.

    Thank you for looking into this.

    Matthew

  • edited May 2005
    I believe I found my solution. Apparently the timing for the calculations
    in the summary were set to traverse instead of ReportEnd. Once I set this
    they included the last group.

    Thank you,
    Matt
This discussion has been closed.