Totalling issue
Hi,
I had put up an earlier post regarding PassSetting ...refer below
----------------------------------------------------------------------
Hi, I have a report that involved a lot of calculations using variables. I
will say its not the best designed as in I would change it to pull figures
from the database rather than use variables to calculate.
Anyway, if I set my PassSetting to onepass and I preview the report page by
page, it doesn't add a figure from a previously printed subreport. if I
navigate to the last page and come back, it adds correctly and the correct
figure is displayed.
If I set it to twopass, it works fine. I have my variables in the OnCalc
events
Any reason why this may be happening?
----------------------------------------------------------------------
I actually get incorrect totalling if I go to the last page directly. Say
report is 6 pages and I go from Page 1 to 6 in the preview window, it fails
to add values from one of the variables. If I navigate through the pages in
sequence than I get the correct totals. Any ideas?
--
RB 6.03
Delphi 6
Cheers,
Shanil
I had put up an earlier post regarding PassSetting ...refer below
----------------------------------------------------------------------
Hi, I have a report that involved a lot of calculations using variables. I
will say its not the best designed as in I would change it to pull figures
from the database rather than use variables to calculate.
Anyway, if I set my PassSetting to onepass and I preview the report page by
page, it doesn't add a figure from a previously printed subreport. if I
navigate to the last page and come back, it adds correctly and the correct
figure is displayed.
If I set it to twopass, it works fine. I have my variables in the OnCalc
events
Any reason why this may be happening?
----------------------------------------------------------------------
I actually get incorrect totalling if I go to the last page directly. Say
report is 6 pages and I go from Page 1 to 6 in the preview window, it fails
to add values from one of the variables. If I navigate through the pages in
sequence than I get the correct totals. Any ideas?
--
RB 6.03
Delphi 6
Cheers,
Shanil
This discussion has been closed.
Comments
Where is the totalling variable located? Please download a trial copy of RB
9.02 and test with that. There have been many fixes having to do with
variable calculations since version 6.03.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
the calcualtion in The OnPrint instead of OnCalc, it seems to work although
I'll have to test it more.
Is there any way to traverse all data when the first page is displayed?
If you have your report set to TwoPass, ReportBuilder will traverse all you
data once before displaying the first page, then traverse the data again as
you view them. The danger in using the OnPrint event rather than the OnCalc
event is that there is no guarantee that the OnPrint event will only fire
once per traversal (especially during a page break).
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com