?
Solved

Query Engine Error

Posted on 2005-03-22
8
Medium Priority
?
474 Views
Last Modified: 2008-02-07
Hello Experts,
I am trying to run a Crystal report from a dataset and keep getting the following error.

Query Engine Error: 'C:\Documents and Settings\CHADMARSH\ASPNET\Local Settings\Temp\temp_3d99a711-7b0c-4196-bc93-b94d70aad41f.rpt'

The steps I have taken so far are:
1. Verified that the dataset is filling
2. Verified that the table in my xsd file exactly matches my report

I have done about everything I could find on the web including all the steps from the Crystal kbase
http://support.businessobjects.com/library/lbase/articles/c2011619.asp

The test report I created only has 3 columns in it from a MSSQL database.
Here is the code from my webform

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim report As New CrystalReport1
        Me.SqlDataAdapter1.Fill(Me.DsReports1, "de_users")
        report.SetDataSource(Me.DsReports1.Tables("de_users"))
        Me.CrystalReportViewer1.ReportSource = report
    End Sub
I would really appreciate any help
Thanks
Chad
0
Comment
Question by:ChadMarsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 2

Author Comment

by:ChadMarsh
ID: 13604587
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13604649
By exactly matching that includes field types and length?

mlmcc
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 13604725
My table has an int and 2 varchars.  The xsd file has the int and 2 strings which I assume is OK since varchar is not an option for in the xsd table.

                  SQL Database            XSD File
ID                        int 4                     int
first_name           varchar 50             string
last_name            varchar 50             string

Could it be the varchar's?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 13607197
I think it could be.  The STRING is probably being treated as a MEMO field where as the varchar is a fixed length.

Can you use TEXT(50) or STRING(50) in the XSD file?

mlmcc
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 13611019
After I posted that, I created a new report with just the ID so both the database and the XSD file only had the
int.  It still gave the same error. Maybe I am doing something wrong in the process of creating.  I don't know if it will help or not, but here are the steps I am doing:
1. Drag a dataadapter to my web form and configure it for the table that I want.
2. Generate my dataset from the dataadapter. I usually go to preview data and fill it just to be sure it's bringing back records.
3. Add a Crystal report.  Select my datasource from Project Data/ADO.NET datasources.
4. Add the fields I want to my report.
5. In the on load event of my  web form add the following code:
        Me.SqlDataAdapter1.Fill(Me.DataSet11, "de_users")
        Dim rpt As New CrystalReport1
        rpt.SetDataSource(Me.DataSet11.Tables("de_users"))
        Me.CrystalReportViewer1.ReportSource = rpt
6. Then I have been right clicking and selecting preview in browser to see if it works.  That's when I get the error.
Maybe this will give a clue to if I am making a mistake somewhere else.
Thanks for the help.
Chad
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 13617877
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 13621221
Thanks for all your help
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13626671
Glad i could help

mlmcc
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question