Solved

Can Crystal Reports .NET use an ADO recordset?

Posted on 2004-10-30
291 Views
Last Modified: 2010-04-23

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?
0
Question by:brokeMyLegBiking
    4 Comments
     
    LVL 69

    Expert Comment

    by:Éric Moreau
    You need to switch to a dataset:

    Me.ReportToPrint.SetDataSource(Me.mdtsDataSet)
    CrViewer.ReportSource = Me.ReportToPrint
    0
     
    LVL 4

    Author Comment

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

    0
     
    LVL 69

    Accepted Solution

    by:
    0
     
    LVL 4

    Author Comment

    by:brokeMyLegBiking
    excellent!
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
    It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    875 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now