2 pass report and variable oncalc
Hi,
I have a report with 2 subreports, each query linked to these subreports
contains records with
the same primary keys and in the same order.
Each subreport contains a variable used to format a field, and this value is
the same for both queries/subreport.
The report is set to 2 passes and the variables are set correctly during the
1st pass, but the oncalc in
the 2nd pass is incorrect for one of the subreport, displaying the value of
another record.
There's no other event that could affect the data or anything similar.
I don't exactly remember why it was set to 2 passes but there was a reason.
Anything known about this?
tks
I have a report with 2 subreports, each query linked to these subreports
contains records with
the same primary keys and in the same order.
Each subreport contains a variable used to format a field, and this value is
the same for both queries/subreport.
The report is set to 2 passes and the variables are set correctly during the
1st pass, but the oncalc in
the 2nd pass is incorrect for one of the subreport, displaying the value of
another record.
There's no other event that could affect the data or anything similar.
I don't exactly remember why it was set to 2 passes but there was a reason.
Anything known about this?
tks
This discussion has been closed.
Comments
I would suggest placing a break point inside the OnCalc of you TppVariable
and track the calculation as the report generates to give you a better idea
what exactly is happening. There are many events that could be used to
alter your dataset but ReportBuilder does not have any logic that will do
that on its own. As a last resort, you might try commenting out all your
event handlers, then periodically begin adding the code back to isolate the
issue.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com