Dynamic Subreport 1

[benlinkknilneb]

Hey all,

I'm writing an app in VB.net that uses CR and I was wondering if it's possible to SetDataSource(___) of a subreport. I've got this set of reports that all has the same parent report and the same structure, but different data sources depending on the user's selection (it's making scatter plots and the user chooses the value for one of the axes). Is there a way to set the data source of the subreport in VB, without changing the parent report?

Ben

 

[synapsevampire]

Check:

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

or

StrSQL = "Select * FROM "QueryName" WHERE "criteria".
Set crApp = New CRAXDRT.Application
Set cr = crApp.OpenReport(App.Path & "ReportName&quot

Set crSub = cr.OpenSubreport("SubReportName&quot

Dim rsSubrpt1 As Recordset
Dim StrSQL1 As String

Set rsSubrpt1 = New Recordset
StrSQL1 = "Select * From "QueryName" WHERE "criteria"

rsSubrpt1.Open StrSQL1, g_conn, adOpenStatic, adLockReadOnly
crSub.Database.SetDataSource rsSubrpt1

-k