Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 1st, 2004, 02:49 PM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query Engine Error ....

Hi I'm having a big headache cause of a problem with Crystal Reports 9.
I built a VB.NET application based on an Access DB that generates reports to be printed.
All of the reports work fine except one that gives the following error:

Error in File C:\DOCUME~1\lorenzo\IMPOST~1\Temp\temp_a1429177-ff7b-4b26-b3f9-710cefe75ee2.rpt:
Query Engine Error

Now, the report is based on a dataset wich is based onto a .xsd schema. The dataset contains several tables linked in the .xsd schema. The dataset is filled in the form and then the Report is called from the form. Code follows:

Dim DaAna As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM Anagrafica WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaQua As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM QuadroCli WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaRefDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = True", oConn)
        Dim DaRefSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = False", oConn)
        Dim DaCoc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Condizioni_ocu WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaLenDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = True ORDER BY data DESC", oConn)
        Dim DaLenSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = False ORDER BY data DESC", oConn)
        Dim DaOcc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Occhiali WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaFat As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 5 * FROM Fatture WHERE id_cli = '" & UGuid.ToString & "' ORDER BY data DESC, n_fat DESC", oConn)

        oConn.Open()
        DaAna.Fill(oDsStampaQuadroCli, "Anagrafica")
        DaQua.Fill(oDsStampaQuadroCli, "QuadroCli")
        DaRefDX.Fill(oDsStampaQuadroCli, "Refrazione_od")
        DaRefSX.Fill(oDsStampaQuadroCli, "Refrazione_os")
        DaCoc.Fill(oDsStampaQuadroCli, "Condizioni_ocu")
        DaLenDX.Fill(oDsStampaQuadroCli, "Lenti_od")
        DaLenSX.Fill(oDsStampaQuadroCli, "Lenti_os")
        DaOcc.Fill(oDsStampaQuadroCli, "Occhiali")
        DaFat.Fill(oDsStampaQuadroCli, "Fatture")
        oConn.Close()

        Dim Rpt As New StampaQuadroCli
        Rpt.SetDataSource(oDsStampaQuadroCli)
        CRV.ReportSource = Rpt

The point is that IT HAS ALWAYS WORKED !!! I cannot understand why now it has gone nuts.
The report contains sub reports based on tables wich are not linked to other tables in the report. I select datas filling them with different queryes.
This progect was compiled about 6 months ago and since then I haven't touched it. Now I started back working on it and I got busted before starting cause of this problem.
I saw around that many suggest to look at a document called "c2011164.asp", but it is not any more avvlible in its location.
I already updated Crystal reports to Service Pack 3, but nothing has changed.

Please suggest something, I'm really running out of ideas.

Thanks

                           Verdun

Reply With Quote
  #2 (permalink)  
Old January 13th, 2005, 01:07 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi I am facing the same problem.. How did you resolve this.. Please help me..

Quote:
quote:Originally posted by verdun
 Hi I'm having a big headache cause of a problem with Crystal Reports 9.
I built a VB.NET application based on an Access DB that generates reports to be printed.
All of the reports work fine except one that gives the following error:

Error in File C:\DOCUME~1\lorenzo\IMPOST~1\Temp\temp_a1429177-ff7b-4b26-b3f9-710cefe75ee2.rpt:
Query Engine Error

Now, the report is based on a dataset wich is based onto a .xsd schema. The dataset contains several tables linked in the .xsd schema. The dataset is filled in the form and then the Report is called from the form. Code follows:

Dim DaAna As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM Anagrafica WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaQua As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM QuadroCli WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaRefDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = True", oConn)
        Dim DaRefSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Refrazione WHERE id_cli = '" & UGuid.ToString & "' AND occhio_DX = False", oConn)
        Dim DaCoc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Condizioni_ocu WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaLenDX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = True ORDER BY data DESC", oConn)
        Dim DaLenSX As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Lenti WHERE id_cli = '" & UGuid.ToString & "' AND occhiodx = False ORDER BY data DESC", oConn)
        Dim DaOcc As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 3 * FROM Occhiali WHERE id_cli = '" & UGuid.ToString & "'", oConn)
        Dim DaFat As OleDbDataAdapter = New OleDbDataAdapter("SELECT TOP 5 * FROM Fatture WHERE id_cli = '" & UGuid.ToString & "' ORDER BY data DESC, n_fat DESC", oConn)

        oConn.Open()
        DaAna.Fill(oDsStampaQuadroCli, "Anagrafica")
        DaQua.Fill(oDsStampaQuadroCli, "QuadroCli")
        DaRefDX.Fill(oDsStampaQuadroCli, "Refrazione_od")
        DaRefSX.Fill(oDsStampaQuadroCli, "Refrazione_os")
        DaCoc.Fill(oDsStampaQuadroCli, "Condizioni_ocu")
        DaLenDX.Fill(oDsStampaQuadroCli, "Lenti_od")
        DaLenSX.Fill(oDsStampaQuadroCli, "Lenti_os")
        DaOcc.Fill(oDsStampaQuadroCli, "Occhiali")
        DaFat.Fill(oDsStampaQuadroCli, "Fatture")
        oConn.Close()

        Dim Rpt As New StampaQuadroCli
        Rpt.SetDataSource(oDsStampaQuadroCli)
        CRV.ReportSource = Rpt

The point is that IT HAS ALWAYS WORKED !!! I cannot understand why now it has gone nuts.
The report contains sub reports based on tables wich are not linked to other tables in the report. I select datas filling them with different queryes.
This progect was compiled about 6 months ago and since then I haven't touched it. Now I started back working on it and I got busted before starting cause of this problem.
I saw around that many suggest to look at a document called "c2011164.asp", but it is not any more avvlible in its location.
I already updated Crystal reports to Service Pack 3, but nothing has changed.

Please suggest something, I'm really running out of ideas.

Thanks

                         Verdun

Reply With Quote
  #3 (permalink)  
Old January 13th, 2005, 02:43 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

And me too.
I use dataset to fill the report. And I get below;
Error in File C:\WINDOWS\TEMP\{00D38B30-AE4C-447F-9008-6E33A9392EE3}.rpt: Invalid Query Engine property.

Who can help us?


Reply With Quote
  #4 (permalink)  
Old January 13th, 2005, 11:50 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In your report Remove Selected Datasbase Fields & Readd them to the report, that will reset it for you, its tedious but it works.



Reply With Quote
  #5 (permalink)  
Old January 14th, 2005, 04:32 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The reports really can be shown at windows 2000 or windows xp server.
But when install it to windows 2003, it incurs such error.

Reply With Quote
  #6 (permalink)  
Old January 27th, 2005, 02:54 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Err Msg: "Query Engine error..." when running a .NET app on a client computer
The information in the article refers to:
Crystal Reports for Visual Studio .NET

Applies to:

Reported version only
Deployment
Runtime Files
ADO.NET

Synopsis

An application uses Crystal Reports for Visual Studio .NET 2002 or 2003 (not Crystal Reports 9 or 10) as the reporting development tool to report off an ADO.NET dataset.

This application runs successfully on the development computer, but when you deploy this application to a client computer, the following error message appears:

"Query Engine error in C:\Temp\YourReport.rpt"

Why does this error message appear and how do you resolve it?

Solution

The error message appears because the runtime files for the ADO.NET dataset are missing from the application setup.

To resolve this error message:

1.Include the following merge modules in the setup project:

• VC_CRT.msm

• VC_STL.msm

You can find these merge modules in the C:\Program Files\Common Files\Merge Modules folder.

2. Ensure that the following files are located in the System32 folder on the client computer, depending on the version of Visual Studio .NET:

• Visual Studio .NET 2002 - Msvcr70.dll and Msvcp70.dll

• Visual Studio .NET 2003 - Msvcr71.dll and Msvcp71.dll


Additional Information
---------------------

For further information on deploying a .NET application, search for crnet_deployment.pdf on our support site:

http://support.businessobjects.com/search



Reply With Quote
  #7 (permalink)  
Old February 7th, 2005, 03:42 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for demon090977 and wzwar.
I found my error is "Query Engine property. " not "Query Engine error...".
I tried every possible method. But failed.
It drived me crazy.
Acturely the report can be viewed in the LAN.
But can't be viewed through the internet.
Your help is appreciation.

Detail:
http://p2p.wrox.com/topic.asp?TOPIC_ID=26173



Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Engine Error jjshah Crystal Reports 5 December 8th, 2005 08:56 PM
Query Engine Error khanhpnd .NET Web Services 2 October 6th, 2004 05:29 AM
Query Engine Error Fallout Crystal Reports 2 September 30th, 2004 01:13 AM
query engine error shanzhu Crystal Reports 1 September 30th, 2004 01:13 AM
Query Engine Error AniFu .NET Web Services 0 June 18th, 2004 02:53 AM



All times are GMT -4. The time now is 04:05 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.