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

Dbf(advantage) version of report explorer demo

edited March 2003 in End User
Hi
I am trying to create a DBF/CDX version of the report explorer demo for
Advantage.

I have converted the tables from ADT to DBF but have had to change some of
the unsupported field types like autoinc (changed to integer), and
Fieldnames1 & 2 changed to fieldname1 & 2 becauser they are too long and
changed them to 254 from 255 characters.

I now can't launch the explorer because of an invalid variant conversion, I
am guessing that it is trying to autoinc the folder id and failing but I
can't find out where it holds the information or what exactly it does when
you launch the explorer as there are no events.

Thanks
Andy

Comments

  • edited March 2003
    On your Advantage alias configuration, make sure you configure it for the
    DBF/CDX table extensions. Run the Advantage Data Architect and select Tools
    | Alias Configuration. Other than that it should just work normally. I have
    used our Advantage end user demo using these extensions and it works fine.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited March 2003
    Hi

    I don't think I explained it properly.
    I have the aliases set up correctly for DBF/CDX but some of the fields in
    the original ADT tables had field types and field names that were either
    incompatible or too long so I changed them.
    Surely you would have had to make these amendments too, the Fieldnames1 name
    is too long and the character 255 fields need to be changed to 254.
    Now when I launch the report explorer it just gives an error
    'Invalid Variant Conversion' which normally points to a null value
    somewhere.
    My guess it is is tying to read an autoinc value somewhere, but I can't find
    where to change the settings.

    Thanks

    Andy


  • edited March 2003
    Hi Andy,


    just curious, why switching from ADT down to DBF?

    regards,
    Chris Ueberall;
  • edited March 2003
    Chris
    I am just trying to use the Report explorer demo but all my tables are in
    dbf format, but the rbFolder, rbItem etc. are supplied only in ADT format
    and I'm guessing I can;t mix on the same form.

    Andy

  • edited March 2003
    Andy,


    I don't think so. The report storage isn't coupled in any way with the rest of your data. You could set up to different databases for every part. But normally one uses the same database.

    regards,
    Chris Ueberall;
  • edited March 2003
    Do you have a blank folder and item database table for the reports or is
    there null data in the tables? Check the data pipeline connections and make
    sure you can populate a DBGrid on a form with the rbFolder and rbItem
    datasources.

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited March 2003
    Hi Jim
    Yes the tables are blank as I had re-create them. I'll populate them and
    try again.

    Andy

This discussion has been closed.