Link to home
Start Free TrialLog in
Avatar of brokeMyLegBiking
brokeMyLegBiking

asked on

Can Crystal Reports .NET use an ADO recordset?


In the VB6 Development environment you could feel an ADO 2.6 recordset into a crystal report like so:

'---set the data source to an ADO recordset
Dim crMyReport as New rptMembershipRoster
crMyReport.Database.Tables(1).SetDataSource rsReportData, 3
'---show the report in a Report viewer
CRViewer1.ReportSource = crMyReport
CRViewer1.ViewReport


Can you do this in the .NET Crystal Reports Designer? If so, what is the syntax?
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

You need to switch to a dataset:

Me.ReportToPrint.SetDataSource(Me.mdtsDataSet)
CrViewer.ReportSource = Me.ReportToPrint
Avatar of brokeMyLegBiking
brokeMyLegBiking

ASKER

Is there a fast way to feel an ADO recordset into a Dataset?

ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
excellent!