By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Query engine error on crystal report based on stored procedure

P: n/a
Dear reader,

I'm having a problem linking a dataset to a crystal report.
I'm using next code. In between I explain my problem

'This code is to fill a dataset with the result of a stored
procedure on an SQL data base

Adapter_Sp_CoparnEmptyAfterDate.SelectCommand.Para meters("@Date").Value =
DateTimePicker1.Value

Adapter_Sp_CoparnEmptyAfterDate.Fill(DataSet_Sp_Co parnEmptyAfterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_Sp_CoparnEmptyAfterDate.Tables(0).R ows.Count())

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSource(DataSet_Sp_CoparnEmptyAfterDate )

'So far so good, but now ...
CrystalReportViewer1.ReportSource = oRpt

This code works perfectly on my PC where I develop: I see the result in the
viewer.
However on a deployment PC I receive error "Query engine error".
The user is exactly the same as on the development pc, so it is not a matter
of autorisation.

Any ideas ?

Thanks and kind regards
Frank
Mar 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found solution myself.

I had .net framework 2.0 installed on deployment pc and crystal reports
version from visual studio 2003 can only work with version 1.1
"Frank Teunen" <fr**********@telenet.be> schreef in bericht
news:wn***********************@phobos.telenet-ops.be...
Dear reader,

I'm having a problem linking a dataset to a crystal report.
I'm using next code. In between I explain my problem

'This code is to fill a dataset with the result of a stored
procedure on an SQL data base

Adapter_Sp_CoparnEmptyAfterDate.SelectCommand.Para meters("@Date").Value =
DateTimePicker1.Value

Adapter_Sp_CoparnEmptyAfterDate.Fill(DataSet_Sp_Co parnEmptyAfterDate)
'This works fine, because the next message box returns the number of
rows.
MsgBox(DataSet_Sp_CoparnEmptyAfterDate.Tables(0).R ows.Count())

'I have a crystal report predefined and based on the same dataset
Dim oRpt As New CrystalReport1
oRpt.Load()
oRpt.SetDataSource(DataSet_Sp_CoparnEmptyAfterDate )

'So far so good, but now ...
CrystalReportViewer1.ReportSource = oRpt

This code works perfectly on my PC where I develop: I see the result in the
viewer.
However on a deployment PC I receive error "Query engine error".
The user is exactly the same as on the development pc, so it is not a matter
of autorisation.

Any ideas ?

Thanks and kind regards
Frank

Mar 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.