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

Random Access Violation on Loading Report from Database

edited April 2003 in General
We are loading reports for printing from a MS SQL Server table. We create
the datasources and pipelines programmatically. For the most part it works,
but for a certain report, it often gives us an Access Violation exception
when freeing the report (either through free or by loading another report
from the database). We have tried creating the report object at runtime or
by using a report created at design time and both give the same result. Any
help would be appreciated.

Comments

  • edited April 2003
    Randall,

    What version of RBuilder do you have. Last week, we also such a problem.
    When loading another report after a specific report, we got an AV (in the
    source of RBuilder). The guys from RBuilder told me I had to install
    version 7, because there seemed to be a problem in version 6.03. Now, after
    installing version 7, all problems are gone.

    Regards
    Wouter Devos

  • edited April 2003
    We are using ReportBuilder version 7.02 in Delphi 5.

  • edited April 2003
    Randall,

    Did you include the source coude of RBuilder 7 in the search path. Maybe
    with this information the guys of RBuilder can point you in the right
    direction?

    Regards,
    Wouter Devos

  • edited April 2003
    Randall,

    If you are not already doing so, try using the same Owner for the report,
    datasources, and datapipelines.

    Example...

    {assuming Self is the Form}
    myDBPipeline := TppDBPipeline.Create(Self);
    myDataSource := TDataSource.Create(Self);
    myReport := TppReport.Create(Self);

    Next try creating the datapipelines statically and get that working before
    you dynamically create them. Once you get this working, then try to do it
    dynamically. If you still get the error, send a small example to
    support@digital-metaphors.com.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2003
    We have had to change the way we are doing things for report distribution
    purposes. Instead of storing in the database we now store as files and the
    problem has gone away.

    Thanks for the input.

This discussion has been closed.