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!

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

Failed to retrieve data from the database

Status
Not open for further replies.
enterprise1177

enterprise1177

Technical User
Sep 27, 2012
8
US
I'm working with two sub-reports (Crystal Pro XI). The first sub-report works fine. the second sub-report is attached with no problem.
When I preview the main report I'm receiving the following error message:
Details: HY000:[Microsoft][SQL Native Client] Connection is busy with results for another command

Both sub-reports use the same table as the main report in regards to the linking of sub-reports.

Any suggestions would be greatly appreciated.
 
Sort by date Sort by votes
Found the solution. Tables were not linked in the second sub-report
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
325
Ivan Kok
Ivan Kok
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
419
hilfy
hilfy
Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
461
Kennymc
Kennymc
PaulWiersma
  • Locked
  • Question
Failed to retrieve data from database
Replies
1
Views
124
kray4660
kray4660
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
363
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top