Join with multiple tables

rbuser

Hello all!

I want to join the following tables:

A-------+
| |
B |
| |
C |
| |
D-------E

From A to D itsn't a problem, but when I want to join to E,
I have to use a "inner join" from columns of E to columns of D and A.

- Is this possible to make this join from the sql query wizard?
- If not:
- Is it possible to replace the sql query wizard with a custom wizard?
- Is it possible to create manually the sql statement and still
without loosing the possibility to specify arguments to the report?

Another question:
- Is it possible to save a report without the streamed
DADE objects in it?
Because this are part of the report it is inpossible to use the
reports on another RDBMS.

Thanks in advance
CL

nicocizik

Hi Christian,

1. Unfortunately it is not possible to join a table with the fields of two
separate tables using the query wizard.

2. You can however replace the query wizard if you like. All of the
dialogs in ReportBuilder are replaceable (with the exception of the
designer). You could go as far as completely creating a new query wizard or
simply adding some functionality to the existing one. Below is a link to an
example of how to create a custom query wizard.

http://www.digital-metaphors.com/tips/CustomQueryWizard.zip

3. Once you edit the SQL manually, you will then loose all the
functionality of the Query Designer in DADE, but you will still be able to
link datasets in code and access the data from the report.

4. Being able to use the same template on multiple databases would be a
cool feature. Currently all database information is saved inside the
template so ReportBuilder can make an easy connection and access the proper
data. Though it is tricky, it is possible to edit the template text on the
fly so it will run correctly on any database you load it from. Many of our
customers have used the following example to edit the text of their
templates from the database. You may be able to do something similar at run
time. Still the easiest way would be to have multiple copies of the same
template configured for diferent databases.

http://www.digital-metaphors.com/tips/EditTemplatesAsText.zip

--