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

EDataError: no SQL statement available

edited August 2003 in General
My application loads one of two different reports, depending on the
state of a checkbox. One of the reports is attached to a plSQL which
is, in turn, connected to a query. The other report is attached to a
plTable which is, in turn, connected to a table.

When I try to print the report attached to the plTable, I get the
following error: "EDataError: no SQL statement available." I do not get
any errors when printing the report attached to the plSQL.

The only query table in my project is open and has a valid sql
statement. Any ideas as to what may be causing this error?

I use:
D6,Update Pack 1 and 2
Apollo Dade for Report Builder
Report Builder 7.02 Enterprise
Extra Devices for Report Builder 2.6
Apollo SDE 6.1.0.15
Apollo VCL and SQL 6.1.0.4

Don Mided
Natural Software Co.

Comments

  • edited August 2003
    Hi Don,

    Where are you assigning the SQL statement if you are using DADE?

    ReportBuilder supports proper TDataSet Pipeline descendents. You may need
    to trace through the DADE plugin you are using to find the problem or
    contact the developer of Apollo DADE for ReportBuilder.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.