How can I link a recordset to a subreport ? 1

[Paulus]

Inside my program I can link a recordset flexible to my report with the following command: Report.Database.SetDataSource DataEnvironment1.rsMyRecordset

But how can I link the Reordset: MyRecordset2 to the subreport ?

 

[mmaz]

Here's some sample code from Seagate:

Set CRSubreports = session("oRpt&quot.OpenSubreport("ADODemo.rpt&quot

'Create the ADO Database Connection:

Set oConn2 = Server.CreateObject("ADODB.Connection&quot
oConn2.Open("ADO DEMO mdb&quot
set session("oRs2&quot = oConn2.Execute("Select * FROM ADODemoTable&quot
Set Database2 = CRSubreports.Database
set Tables2 = Database2.Tables
set Table1s = Tables2.Item(1)
CRSubreports.DiscardSavedData

Table1s.SetPrivateData 3, session("oRs2&quot

HTH...

 

[Paulus]

Thanks for the answer... but I forgot to tell you that I´m using Visual Basic Version 6 Prof. Your answer I think is a solution for ASP ?!

 

[mmaz]

Correct, the code is for ASPs. But I'm positive you can find the sample code that you need at Seagate's web site:

http://support.seagatesoftware.com