Variables and Keep-Together
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.
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.
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Unfortuanetly I only have access to delphi4 with RB6.0
I'll see if I can "borrow" another version....
Cheers
Alan