Error in Delphi + Report Builder Explorer
? Hi
I'm testing Report Builder and came across a problem with report
explorer. Maybe you can help me!
I've created two tables in my mysql database with the layout shown in
the Developer's Guide, for the folder and items.
I've linked them to the Report Explorer via a couple of DBPipelines, and
created an action that executes the report explorer (also linked to a
designer and it's associated report).
When I first ran the the report explorer, it works fine. I create a
folder and a report, added the fields I wanted, previewed and saved, all
like it should.
In the database, both the folder and the report appear in their
respective tables.
Now the proble:
I can't run the report explorer again.
Everytime I try, the error "Could not convert variant of type
(UnicodeString) into type (Double)" is raized by report explorer itself
(even before the OnActive is fired).
The error keeps shoing everytime I run it, unless I delete the report in
the database items table. Now it runs again, until I save another report.
Anyone knows what might this be?
I'm using Delphi XE with ReportBuilder 12.03
Thank you
Nuno
--- posted by geoForum on http://www.newswhat.com
I'm testing Report Builder and came across a problem with report
explorer. Maybe you can help me!
I've created two tables in my mysql database with the layout shown in
the Developer's Guide, for the folder and items.
I've linked them to the Report Explorer via a couple of DBPipelines, and
created an action that executes the report explorer (also linked to a
designer and it's associated report).
When I first ran the the report explorer, it works fine. I create a
folder and a report, added the fields I wanted, previewed and saved, all
like it should.
In the database, both the folder and the report appear in their
respective tables.
Now the proble:
I can't run the report explorer again.
Everytime I try, the error "Could not convert variant of type
(UnicodeString) into type (Double)" is raized by report explorer itself
(even before the OnActive is fired).
The error keeps shoing everytime I run it, unless I delete the report in
the database items table. Now it runs again, until I save another report.
Anyone knows what might this be?
I'm using Delphi XE with ReportBuilder 12.03
Thank you
Nuno
--- posted by geoForum on http://www.newswhat.com
This discussion has been closed.
Comments
My first suggestion would be to upgrade your version of ReportBuilder to
12.05 and re-test. This is a free upgrade for registered RB 12 users.
Send your serial number and purchasing email address to
info@digital-metaphors.com for upgrade instructions.
Once you have upgraded, try running one of the various End-User demos
located in the Demos section.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
provided a mySQL example that includes a SQL script for creating the report
explorer tables. This resolved the issue.
The error was caused by the report explorer items table not being defined
correctly, specifically the created and modified fields were defined as char
when the should be double.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com