i am using dataset(xsd)(only one Table) is the report source of Crystal Reports in .net. it is working fine.

in xsd i created more than one table and accessing 1 st is Main report and 2nd is for subreport.

remember i created datatable in Dataset file (xsd) is temp Tables that it is not draged from DataBase

the code is

dim report as new CristalReportViewer1
.....
...created DataTable and inserting data into Table
and assign to dataSet


Dim subReport as New ReportDocument
subreport = report.OpenSubreport("subreport name")

report.DataBase.Tables(0).setDataSource(ds)
'''''' ds dataset is for main report

subreport.DataBase.Tables(0).setDataSource(ds1)
''' ds1 dataset is for Subreport


crMain(my Crystal Report in aspx page).ReportSource = report



The Error i am getting is
CrystalDecisions.CrystalReports.Engine.DataSourceE xception Query Engine Error.c:\docume~1\suresh\aspnet\locals~1\temp\temp _a2e7dda7-6191-41d8 9ec3-6570788e320d.rpt

can u please respond my question

Yup, anyone out there can help us out. i am also facing this trouble.
I cannot create a crystal report in VS2003 (version 1.1) using MORE than 1 table. With 1 table its totally fine.

I get the following error:
CrystalDecisions.CrystalReports.Engine.DataSourceE xception: Query Engine Error: 'C:\DOCUME~1\.......................temp_7e93dc03-3a7e-4533-be71-9d75ffcda3fb.rpt'

Please help

I see your problem.

In order to run a report on multiple tables those tables must exist in the same dataset. Create a data adapter for each table

*** VB.NET
Dim da1 as New OleDbDataAdapter()
Dim da2 as New OleDbDataAdapter()

da1.fill(ds)
da2.fill(ds2)

** C#
OleDbDataAdapter da1 = new OleDbDataAdapter();
OleDbDataAdapter da2 = new OleDbDataAdapter();

da1.fill(ds);
da2.fill(ds2);