One report with two data source using RDC

[Caltang]

Hello all,
is there any method show two table records,where the first one is above the seoncd one, wihtout using subreport?graphically:

Table1.record1
Table1.record2
Table1.record3

Table2.record1
Table2.record2
Table2.record3

 

[balves]

One way is to use a FULL OUTER JOIN between the two tables. A FULL OUTER JOIN is essentially a LEFT JOIN followed by a RIGHT JOIN.

You would have to manually edit the SQL as the Visual Linking Expert does not offer FULL OUTER JOIN as a link choice, but it does work. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
(Currently available for consulting in Chicago)

 

[balves]

Actually, a better way might be to write a stored procedure that created a temporary table #T1, then did a SELECT from the first table into #T1 and then a SELECT from the second table into #T1. In this case, the data from the two tables would need to line up, data type-wise in the temp table. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
(Currently available for consulting in Chicago)