Variable not calculated (?) after page break

rbuser

On detail band I have some variables to be calculated and also some totals
on groups footers. Timing for variables is set to traversal. The problem is
that after page break calculations are not working properly within the same
group. On the other hand when timing is set to DataPipelineTraversal it
works, but I have wrong totals. Calculations are based on other pipelines,
maybe that is an issue?

I have also observed that when I have StaticHeight it works fine with
traversal calculations. Unfortunately I need a DynamicHeigth...

I have RBuilder ver. 7.02

Thanks,
Joanna Wolny

nicocizik

Hi Joanna,

Calculating totals across pages with a dynamic height detail band was a
limitation in ReportBuilder until Version 9 was introduced. ReportBuilder
9.03 now contains more enhanced logic to handle this case however there are
some instances that still cause problems (for instance when there is a
region with KeepTogether set to true in a dynamic height detail band). My
suggestion would be to download a trial version of RB 9.03 and see if your
calculations work correctly with that. Be sure to back up any templates you
load into the new version before testing.

--
Regards,

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

rbuser

Thank you for a fast reply .
But... is there a ghost of a chance to check it under Delphi5??? Or maybe
some magic tricks I could try to solve the problem?

Regards,
Joanna


are
you
totals
pipelines,

nicocizik

Hi Joanna,

I apoligize, I did not read your first post correctly. Calculating sums in
the group footer with a dynamic height detail band has always worked
correctly with ReportBuilder. I believe the problem may lie in that fact
that the sum is being calculated based on a datapipeline different from the
one connected to the report. Where is this pipeline located and how is the
data being traversed? Note that if a pipeline is not connected to a report,
the data will not be traversed to calculate a sum.

--
Regards,

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

rbuser

Hi Nico,

I will try to explain the problem again.
Let's concentrate on the first situation. I have:

PipelineMain as a main source for a Report.
PipelineCalculations as an auxiliary one, its DataSource is filtered on
PipelineMainTraversal (GroupABeforeGroupBreak didn't work while changing
between pages...) to assure correct data.

Var1, VarPercent,
VarTotal1, VarTotalPercent

Where Var1 and VarPercent timing is Traversal. Var1 Calculations are based
on PipelineMain, Var2 is (Var1/
PipelineCalculations['VAL_BRUTTO']).

==============================
GroupA

1. Var1 VarPercent
2. Var1 VarPercent
...
n -> everything works fine
--------PAGE BREAK--------
n+1 Var1 VarPercent -> !!!!!! VarPercent wrong Value !!!!!!
n+2 Var1 VarPercent -> Correct

End of GroupA
==============================

It seems that PipelineCalculations['VAL_BRUTTO'] and page break has
something to do with that. What suprises me is that when I set Detail to
StaticHeight it starts to work fine. It also works fine with Var1,
VarPercent timing set to DataPipelineTraversal, but then problem with totals
occures...


Best regards,
Joanna


in
the
the
report,
maybe
templates
the
it

nicocizik

Hi Joanna,

How is ValPercent wrong? Is it adding the next value from the next page?
Is the number completely incorrect? I feel I could get to the bottom of
this issue if I could see this in action and trace some of your code with
ours.

If possible, please send a small example demonstrating this issue that I can
run on my machine in .zip format to support@digital-metaphors.com and I'll
take a look at it for you.

--
Regards,

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