How to pass two recordsets for a report/subreport?

[heynickx]

I'm working with VB 6.0 and CR 8.5.
I want to fill using VB a report with subreport via two recordsets (one containing general info, the other more details). Each time the subreport looks for the link with the report a dialog box pops up asking for a parameter value. This should be done internally by CR.
Is this possible?

 

[synapsevampire]

Are you using the RDC, or ???

Check this:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/scr8_vb_rdc_subreports.exe.asp

-k

 

[SurfingGecko]

If you are using the RDC, you could also have a look at this paper on ADO and ttx files and how you can pass the recordsets in.

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

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

 

[shokti]

try this code snippet...

crxReport.Database.SetDataSource rsSample1, 3, 1
crxReport.Database.SetDataSource rsSample2, 3, 2
crxReport.ReadRecords

rsSample1 & rsSample2 are ADODB.recorset. number 3 is default dont change that. 1 & 2 are the index of the tables in your report.

i hope this helps.