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

ReportBuilder Sub-Report Complexity

edited March 2003 in Subreports
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?

Comments

This discussion has been closed.