Crystal Reports Error message

Posted on 2006-05-24
Last Modified: 2010-05-18
Hi All,
We have created a C# remoting application that uses CR 10 for report writing.  Crystal gets the information from an XSD that we create and pass to Crystal.  We get an error message at times (I can not find a pattern) when a report is going to be displayed as follows:

CrystalDecisions.CrystalReports.Engine.DataSourceException: Unknown Query  Engine Error  
Error in File  
Unknown Query Engine Error ---> System.Runtime.InteropServices.COMException  
Unknown Query Engine Error  
Error in File  
Unknown Query Engine Error  

I have only found one other posting that has the same problem.  It is located here:

No one ever answered the question, so I do not know what might be causing the problem.  Has anyone seen this problem before?  

Any help would be greatly appreciated.

Question by:smpross
    LVL 12

    Accepted Solution

    I see this error when the report does some kind of joining/selection record operation and the datasource doesn't contain relevant data.

    For example say TableShape has a shape_id field and TableSquare has a shape_id field that references the TableShape.shape_id
    so the query would be something like select * from TableSquare, TableShape where TableSquare.shape_id = TableShape.shape_id.

    If one or both of these tables are empty, the report(s) always give me the same error as you are seeing.


    Author Comment

    Thanks.  But the strange thing is that if I exit the application and restart the application and run the same report with the same parameters, the report runs fine.  Any ideas what might cause that?

    LVL 12

    Expert Comment

    Sorry, Scott.

    My experts-exchange emails started getting treated as spam so I missed your original response.

    Does your report have the Discard saved data option checked or unchecked..

    another out there possibility.. are you doing trying to reintialize the com objects when running the report for the second time in your application.. OR cleaning up all of the com / crystal stuff and then trying to re-communicate?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    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…

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now