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!

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

Status
Not open for further replies.
josefin

josefin

Programmer
Oct 29, 2002
26
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
  • Locked
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
1K
Joshua44
J
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
263
hilfy
hilfy
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
216
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
215
SarahSCPDAdmin
SarahSCPDAdmin
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
154
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top