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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report - Failed to retreive data from the database

Status
Not open for further replies.
Tstegen

Tstegen

Programmer
Nov 10, 2008
10
NO
I have a report With 3 sub reports.
When running this report in Runtime, Crystal report Viewer gives the error 'Failed to retreive data from the database' without any additional information.
I have tried for run the SQL for the reports (main report and sub reports) manually in SQLtools and they run OK ang gives the expected result.
The linked Field is the SID, and I have checked at the sid is present in the linked table in the sub reports.

 
Sort by date Sort by votes
Which version of Crystal are you using? Does the report run correctly when you open it directly in Crystal and not in the viewer?

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
498
Kennymc
Kennymc
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
354
Ivan Kok
Ivan Kok
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
457
hilfy
hilfy
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
372
dgillz
dgillz
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
361
Gary Hnat
Gary Hnat

Part and Inventory Search

Sponsor

Back
Top