Crystal Report Query Engine error

[Johnsy]

Hi,
My project is being done in Vb.Net 2003 and SQL Server2000. When I try to access the Crystal Report thru code only I get the query engine error. the Sql Query however works perfectly in Query Analyser.
The Query uses left outer join operation from 4 tables. Is there any way I can overcome my error?

Thanks in advance
Johnsy

[wapper]

It could be useful to know exactly what error message says, to figure out if we're dealing with connection problem, or there is an error in query.
Also, you could try running Profiler to see what happens on SQL Server when you run your report.

[samsubh]

hi johnsy,

i too got the same problem . please tell me the solution if had solved tat problem.
how to create dataset.xsd for 2 tables