We have created a report using Crystal Reports 10. Then we are publishing to Crystal Enterprise Professional 10. When users access this particular report they receive a query engine error. This error seems to show up randomly (shows while picking values, moving to next page, or while executing). Does anyone know what the cause of this error is? Help would be greatly appreciated. This error seems to only show up on this one particular report out 14 reports that we have out there.

hey, i used
report.SetDataSource(ds.Tables[0]);
and my program ran which was earlier giving "Query engine error"
as i was writing
report.SetDataSource(ds);

I****a

i****a

i****a

 hey, i used
report.SetDataSource(ds.Tables[0]);
and my program ran which was earlier giving "Query engine error"
as i was writing
report.SetDataSource(ds);

Ishi


i****a

hi, there,
I've got the similar problem. Have you solved it yet?

Cheers,
yaduo

problem solved, the second solution in the following link.
http://aspadvice.com/blogs/rjdudley/...5/13/2589.aspx

my code originally use adapter.fill(dataset);
when I change it to adapter.fill(dataset, "tablename");

I thought it is rediculus to add a tablename since the adapter has setted a select command on a specified table, but, it turns out the crystal report do need this rediculus confirmation.

Good luck to all of you who found this thread.