EDataError: no SQL statement available
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.
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.
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com