[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Error Opening a recordset in Crystal Report .NET

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.
0
askmeaks
Asked:
askmeaks
  • 2
1 Solution
 
karthikeyanTPCommented:
>>> 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.

0
 
karthikeyanTPCommented:
check your select statement whether it is indeed returning rows
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now