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

Crystal Reports Error In file C:\...ReportName.rpt Query Engine Error

Status
Not open for further replies.
josefin

josefin

Programmer
Oct 29, 2002
26
0
0
NZ
The report is running on oracle 9.i and is written using crystal v.9. It contains a subreport which runs off a view, and the main report runs off a view. Has anyone seen this error before?

 
Sort by date Sort by votes
Need more info...

Does the report run without the subreport?

Does the subreport run on its own without the error...

Start there... after that we can explore more possibilities...

Also - what driver are you using for Oracle?
 
Upvote 0 Downvote
Could be numerous things.

Including the connectivity used. For instance you should be using Oracles Native connectivity in Crystal, or if ODBC, which is slower, use the Crystal supplied ODBC, Not Oracles.

You can also copy the SQL from each report for testing by using Database->Show SQL Query.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
1
Views
181
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
143
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
111
SarahSCPDAdmin
SarahSCPDAdmin
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
90
SoftwareRT
SoftwareRT
CodeWell
  • Locked
  • Question
Crystal Reports RPTR Format Not Available
Replies
2
Views
88
CodeWell
CodeWell

Part and Inventory Search

Sponsor

Back
Top