ReportBuilder Sub-Report Complexity

rbuser

I am using Delphi 6 and ReportBuilder 7.01.
I have a main report with about 8 sub-reports so far.
I have another sub-report that I need to link to my main report.

The query is something like this.

Select
Several Columns
From
3 tables
Where
The 3 tables are joined appropriately including an outer join to the 3rd
table.
And
One of the columns is equal to the value of a select query returning a
value like the column
And
Two of the columns are directly equal to values in the main table or are
null (accomplished by outer join).

The problem I have is that I can't seem to do a nested select in the Data
area.
This leaves me with making a query and using the joins directly.
The problem with this is that I want to return data for the sub-report where
the subquery matches
and the other two columns either match or are null.
The Data area also doesn't seem to allow multiple joins for one table, so
this seems to be impossible.
Any suggestions?

digitalmetaphors

Create another detail dataview and make a second visual link. This way you
have two detail dataviews for one master dataview. Now connect the new
subreport to the new detail dataview. Does this not work?


Cheers,

Jim Bennett
Digital Metaphors