Error Opening a recordset in Crystal Report .NET

Posted on 2004-11-07
Last Modified: 2010-04-24
I'm currently developing an application in VB.NET 2001. I'm using Crystal Report shipped with Visual Studio.NET 2001. The problem is that, when I try to open a recordset in one of the reports, the recordset containing 269695 records, the Crystal Report Viewer returns a message — "Could not open recordset", and displays no records. Moreover, it is unable to display the lines and boxes drawn on the report. And all the buttons on the report viewer control is disabled. I'm using SQL Server 2000 as a backend.
      Would somebody give me a solution to my problem. It's urgent.
Question by:askmeaks
    LVL 2

    Accepted Solution

    >>> to open a recordset in one of the reports, the recordset containing 269695 records, t

    Why are you retrieving such a huge number of records 269695 one time? Do you have WHERE clause in your select statment?

    If you really want to retrieve such huge number of records at a time, use DataReader (can quickly access data once, in a forward-only and read-only manner). Get records in chunks instead of a lot at once. You can modify your WHERE clause everytime you fetch records.

    LVL 2

    Expert Comment

    check your select statement whether it is indeed returning rows

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    733 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

    23 Experts available now in Live!

    Get 1:1 Help Now