Data Definition File (TTX) and JOIN

[kennedymr2]

I am designing a Crystal (v9) Report using a
Data Definition File (test1.ttx)
I am doing this , as i do not wish to attach a database to the report, as i have an option to connect to the server over the internet .

This file contains all the field names etc of a table say called Table1.

I have this report work perfectly ok.

I am attaching an ado recordset to the object. see below.

SQL="Select * from Table1"

Set rscry = New ADODB.Recordset

With rscry
.ActiveConnection = Cnn1
.CursorType = adOpenKeyset 'Move the cursor in any direction and bookmarkable
.LockType = adLockOptimistic 'Editing is possible
.Source = SQL 'What Recordset to get
.Open
End With


m_Report.Database.SetDataSource rscry

BUT.. Now i need to link another table to Table1 ( Say Table2) the link key is Tblid. Need to still using .ttx (data Definition Files)
I now have table1.ttx and table2.ttx

Is this possible????, How do i get this to work.

Appreciate any help

 

[pgtek]

hi
read this article it might help you

http://support.crystaldecisions.com/communityCS/TechnicalPapers/adosubrep.pdf

cheers

pgtek

 

[kennedymr2]

Thanks pgtek,
I will have a try at this example code.
Looks pretty complicated just to get two recordsets.

Thinking i must just create a temp file with both the tables merged??!!!@!@, but maybe not, will have a go at the example.

Appreciate the help