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

database joins

edited January 2003 in End User
Dear all,
following advice last month, I have used the data dictionary
component to populate the tables and fields, and not the joins. I do not
want the suggested joins based on same filed names.
I have then added the join in the data dictionary. I have checked the
database using Enterprise manager and the record looks fine.

When I use the reporting tool to create a new report, and use a new data
wizard, I choose the two tables and it immediately suggests a join using the
same field names and totally ignores the join I have defined.

How do I get the data builder to use the joins I define??

regards

--
John Evans
Technical Director
Clear Advantage Ltd

www.Clear-Advantage.co.uk

Comments

  • edited January 2003
    Set UseDataDictionary to true in the designer's Datasettings property, or at
    runtime in the datasettings dialog of the Data tab. If you don't tell the
    designer to use the data dictionary, it will try to join on those fields
    automatically as a suggestion.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited January 2003
    Dear Jim,
    many thanks.

    I now have the database structures I want in my rb_xxx tables. Is there an
    easy way of writing a program to update the database of my customers to
    build all of the tables?

    regards
    John



  • edited January 2003
    Hi John,

    There are SQL scripts in our demos which create the end user tables for the
    folders, items, tables, fields and joins. I searched on older posts but OE
    is not finding your oldposts so I could see what DB you are using. Anyways,
    for your database, look in the applicable RBuilder\Demos\EndUserDatabases
    directory for and example script or sample tables.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited January 2003
    Dear Jim,
    sorry, I am misleading you. I can see how to use the scripts to
    create the tables, I want to populate them once they have been created,
    using the data in my database. The database is SQL server.

    regards
    John

This discussion has been closed.