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

Problem 'Could not Open Dataset : '

edited April 2004 in Server
When creating a report and running it in the designer everythign works fine.
Afterwards it is stored in the database.

When running the report in a server i'm getting the error 'Could not open
DataSet.: Complex'

This Complex is a dataset in DADE, the main report's dataset is a hardcoded
one in the Webmodule.

But, on e second report, with a slightly different layout the same dataset
are working.

This is not the first time i had the problem but until now i each time
deleted my datasets and recreated them. Is there a way to trace this what is
going wrong where ????

Comments

  • edited April 2004

    Couple of possibilities come to mind:

    1. The dataset cannot be opened because the data connection object cannot be
    found. For example, if you create a report that connects to a TDatabase
    object named 'euDatabase', when you save the report, the DataView's TdaSQL
    object saves the name of the database object.

    When you create the ReportVolume module for the server, you would need to
    have a TDatabase object with the exact same name on the module. Otherwise
    the report will not be able to connect to the database.

    2. You might have naming conflicts somewhere.

    Keep in mind that the report and all elements within it are Owned by the
    form/datamodule upon which the ReportVolume resides. When a report loads, if
    there are other objects within the same Owner that already use the same
    names, then the objects that are loaded must be renamed.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited April 2004
    Nard, double naming conflict. I had to stop placing the report on the
    datamodule.
    Before a build i always did a new report, but afterwards i've seen that this
    doesn't delete the datasets .......

    Thx

    and, up to the next post
This discussion has been closed.