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

QueryDesigner,DataTab and Advantage Tables

edited November 2002 in End User
I am trying to implement the datatab for Reportbuilder 6.03, Delphi 5,
and Advantage Local server 6.2, so I can use the QueryDesigner and
QueryWizard. I have placed the daDatMan.pas and daADS.pas in
the path and have made the correct settings in the Data Settings.
I now get the DataTab, QueryDesigner and QueryWizard within
the File/New of the Report, however no tables show up. I have looked
at the example that comes with Reportbuilder and it does the same thing
unless I use the datadictionary option. Then the demo tables show up.

I have noticed that the demo is distributed with version 5.5 of
Advantage. Could this be the problem? I am using the latest version.
Is there a newer version of daADS out.

Does anyone have a working example of using Advantage with Report
Builder?

Any help would be greatly appreciated as I am stuck in the water, so to
speak.

Thanks,

Brian

Comments

  • edited November 2002
    Are you using the Advantage data dictionary? Disconnect that data
    dictionary. You should use the ReportBuilder data dictionary component in RB
    6.03 to control the tables, fields and joins available to the report
    designer. The daADS.pas that ships with RB 6.03 doesn't support the
    Advantage 6 data dicitonary feature. Currently, RB 7 has an issue with the
    current Advantage data dictionary when using linked data dictionaries, but
    it should work with a single Advantage data dictionary. You can upgrade to
    RB 7 to get the latest support for Advantage 6 in RB. When the linked data
    dictionary support comes out, you'll be able to get support for that if
    you're using RB 7. However, we won't force you to upgrade to RB 7, just to
    get the latest plugin. However, you'll have to modify the 6.03 version of
    the plugin based on the 7 version of the plugin. The architecture is a
    little different because RB 7 supports thread safety. The changes aren't
    drastic, just a couple of interface section changes in the plugin. I can
    send you the RB 7 plugin and you can adapt it to work in RB 6.03. It
    basically adds a couple of methods that get the data from the Advantage data
    dictionary. Compare the two files and it should be easy to build a working
    version.

    Send an email to support@digital-metaphors.com and we'll send you the RB 7
    daADS.pas.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited November 2002
    I have projects that use both. How or what do I do for a project that
    does not use a data dictionary.

    Brian

  • edited November 2002
    If you are using the Advantage data dictionary, you'll want to use the same
    plugin for both projects. There is a selection statement in the latest
    plugin to get the tables from either the Advantage datadictionary or from
    the normal ways: hit the database, read our data dictionary or read from the
    meta data cache. I can send you the latest RB 7 daAds.pas and you can adapt
    the new code to your 6.03 version of daAds.pas so that it can work this way
    for you.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.