Unknown query engine error with crystal reports

[crystalReporterNew]

Hi,

I am using crystal reports with VB.NET. I get the data from a MYSQL database thru a select statement and set the datasource in the crystal report viewer and do a form show in the end.It gives me an "Unkown query engine error" at runtime. Everything is correct including the results of the query obtained, but why is this error message showing up? The crystal report hence displayed does not contain any data.
Please help
Thanks

 

[crystalReporterNew]

Hi again,
For some more insight, what I am doing is actually I am connecting to a MYSQL database on a server and copying the data into text files on a local machine. I use a file DSN to configure the text database and run queries on it. The queries are executed and give the correct result when displayed in a grid, but when I do

crReportDocument.Database.Tables(0).SetDataSource(dataset1.Tables(0))
Dim F2 As New Form2
F2.CrystalReportViewer1.ReportSource = crReportDocument1
F2.Show()


Then it gives me the Unknown query engine error.
Also, if I remove the bar graph from my crystal report it works fine but when I insert the bar graph then it gives problems. I wonder if it has anything to do with grouping. I have tried everything.
Please help

 

[GISDan]

Hi,

I am not sure if you have checked this yet, but it may be a place to start. I also had the same error message "Unknown query engine error" using CR 9.0 After looking at the patches, I found out my problem was a selection that I was applying to a join in my sql statement. Try this URL for the latest patch from CR.

http://support.businessobjects.com/fix/hot/si75/

Hope this helps

 

[tonioJ]

Hello GISDan,

i think i have a similar problem with you. what have you done to your selection? i am using this statement in my sql stored procedure:

select a.cocode,
a.paymentno,
a.paydate,
a.paidto,
a.totalAmount,
isnull(a.remarks,'') as remarks,
a.Status,
b.OrderNo,
b.AcctCodeCom,
b.AcctDesc,
b.Amount
from pcs_paymentshead a
left outer join pcs_paymentdetails b on a.cocode = b.cocode and a.paymentno = b.paymentno


what do you think is wrong with this? is it my query or this is bug in crystal report?