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

Count Error in Report Explorer

edited October 2004 in Server
When a report is displayed in the Report Explorer view (via browser),
the sums at the end of the report are incorrect. Even more odd, is that
the sums are correct at times. The data (SQL Server 2000) is stable and
has not been updated (so it can not be blamed for the numbers changing).
the wrong totals show up if the user displays the first page of a
report and jumps to the last page of the report. If the user paginates
from one page to the next, until he arrives at the last page, the sum is
always correct. To compound the issue, when using the PDF Print icon (we
are using Pragnaan), the total is always incorrect. Is this a WebCache
issue? Any help here would be appreciated.

In the short term, I have instructed my users to paginate to always
obtain the correct sums--obviously not a long term solution.

rrr

Comments

  • edited October 2004


    I think if you run the report in a standard application you will see the
    same behavior. This is not related to the server.

    You need to use the TppVariable component and its OnCalc event to perform
    all calculations. Check out the articles posted to the Calculations thread
    of the Tech Tips newsgroup.





    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited November 2004
    When I run the report from Report Builder (a desktop application) the
    counts always come up correct. So it looks like the calculation works as
    intended; just not consistently from a web browser with Report Explorer.
    What should I try now?

    rrr

  • edited November 2004

    As a test, comment out all event-handler code associated with the report.
    Make sure that you do not have any event-handler code that manipulates the
    dataset in any manner while the report is generating.

    If you still have issue, please create a simple example that demonstrates
    the behavior. Use standard Delphi components, ReportBuilder and the DBDemos
    data (or send us some paradox or MS Access tables). Make the demo as simple
    as possible - something that shows the behavior, not your real world report.
    Email in zip format to support@digital-metaphors.com in zip format.



    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.