Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to access first record

Status
Not open for further replies.

OnDOT

Programmer
Jul 20, 2001
11
SG
Hi,

Need help urgently here.

I encounter an inconsistent error here.
Sometimes when I run the same report but with different paramenter values, e.g. Invoice number, when the CRViewer forms loads up and tries to display the report, the following error messages pops up:

1) Seagate Crystal Reports:Database Error
Unable to access first record!

2) Crystal Report Viewer:
SQL Server error

If I attempt to close the form and reload again, and it works fine. I wonder what kind of mistake have I made in my codes? or is there any patches for such cases.

I tried unselecting under the Report->Report Options->"Use Indexes or Server for Speed"


Regards,
Eric Lye
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top