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

Error in Delphi + Report Builder Explorer

edited January 2012 in General
? 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

Comments

  • edited January 2012
    Hi Nuno,

    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2012
    This question was also sent to support@ and included more details. I
    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
This discussion has been closed.