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

Variables and Keep-Together

edited April 2003 in General
I have a report, on the detail I have a sub report.
I need to total the values of a field in the sub report, and this total
placed on the main report in the summary.

Now, the sub report is in a region to keep everything together.
I am using a dbcalc (on the main report - in the summary) and summing the
value of the field of the pipeline in the subreport. I am also using a
variable in the subreport, on the detail and adding up the value of the
same field.

Both give me the same answer.

NOW, if I switch on the region's "Keep together", both give me the same
answer, but it is an incorrect answer!
When the report spills over to another page, the variable and dbcalc are
adding the first line of the detail in the sub report TWICE.
If I leave Keep-together off, all is ok.

I have looked through the group, but could find no real answer to this,
what was said is that it caches the variable, so it shouldn't calc it twice
.

My report is set to 2pass, with cache pages on.
using Delphi 4, with RB6.0

Can anyone give me some light on how I can get a correct answer with keep
together on. the report looks a lot better and more proffessional with it
on!

Thanks
Alan.

Comments

  • edited April 2003
    Alan,

    If you have access to Delphi 5 or above, try testing with ReportBuilder 7.02
    Trial Edition and see if the issue is resolved. I was unable to recreate
    the issue on my computer using RB 7.02 with Delphi 7. Feel free to send an
    example to support@digital-metaphors.com and we'll take a closer look.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2003
    Hi,

    Unfortuanetly I only have access to delphi4 with RB6.0

    I'll see if I can "borrow" another version....

    Cheers
    Alan

This discussion has been closed.