Query Engine Error in Web Application

Posted on 2006-04-27
Last Modified: 2012-08-13

I have a web application where I use Crystal Reports.
I have set the datasource to a Dataset. Everything works fine in the developing machine.
When I upload the application to the server it gives me an error when viewing the report.

Exception Details: CrystalDecisions.CrystalReports.Engine.DataSourceException: Query Engine Error: 'C:\DOCUME~1\WEBSENSE\ASPNET\LOCALS~1\Temp\temp_d7f693d2-f955-49b7-ba03-5872073be60f.rpt'

Any idea what the error means?

Question by:carlosmonte
    LVL 100

    Expert Comment

    Could be a lot of things.

    How are you setting the data source?

    LVL 1

    Author Comment

    I fill a dataset with a SQLDataAdapter with the SelectCommand that I need as a datasource:

    CommandText= "SELECT C.ControlDate AS ControlDateAll, P.EmployeeID AS EmployeeID, P.CoNumber AS CoNumber, P.FirstName AS FirstName, P.MiddleInitial AS MiddleInitial, P.LastName AS LastName, P.BaseDepartment AS BaseDepartment, D.DeptNo AS DeptNo, D.DeptName AS DeptName, P.PalSoftID AS PalSoftID, T.* FROM dbo.TblMasterCalendar C LEFT OUTER JOIN (SELECT * FROM vwPalaceConsolidatedTcDetailFileAndHistory WHERE companynumber =" & coNum & " AND department IN (" & departmts & " )) T ON C.ControlDate = T.ControlDate LEFT OUTER JOIN dbo.vwPalaceConsolidatedPrMaster P ON P.EmployeeID = T.timeclockid AND T.companynumber = P.CoNumber LEFT OUTER JOIN dbo.vwPalaceConsolidatedPrDepartments D ON T.Department = D.DeptNo AND T.companynumber = D.CoNumber LEFT OUTER JOIN dbo.TblMasterCompanyNames TblMasterCompanyNames ON P.CoNumber = TblMasterCompanyNames.CoNumber WHERE (MONTH(C.ControlDate) = " & month1 & " ) AND (YEAR(C.ControlDate) = " & year1 & ") "

    Then I pass that dataset as the reportSource:
    LVL 1

    Accepted Solution

    Got it!
    The deployment machine was missing two merge modules: Msvcr70.dll and Msvcp70.dll
    I did include them in the Setup project. However the modules where contained in the application folders but not in the machine's \System32\ folder.
    So I just copied the modules to \WINNT\System32\
    Worked just fine after this. For reference here is the BO article


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    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…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now