I will start from the scratch.

1. First you have to create a XML dataset file which can be done by right
clicking on your project (Solution Explorer) Add - Add New Item then choose
Dataset. Design your dataset which is pretty straight forward.

2. Now design the report using the Dataset you have created above which can
be done by right clicking on your project (Solution Explorer) Add - Add New
Item then choose Crystal Reports this time. You will be prompted for the
data instead of using the normal way (ie tables) choose Project Data then
choose ADO.NET Datasets. Now select the one you have created in Step 1 and
start designing your report based on that dataset.

3. Now coming to your coding...

Instead of using the standard Dataset. Create a new instance of the Dataset
that you have created in Step 1

Dim ds as New MyDataset() 'The dataset that you have created in XML

4. Fill this Dataset with data as you do for anyother Dataset.

5. Create a new instance of the Crystal report.

Dim report as New MyReport()

6. Now do the binding

 reporpt.SetDataSource(ds)
 ReportViewer.ReportSource = report

Basically once you understand the flow it's very straight forward creating
Reports using Datasets.

hey, i've solved it myself !

Did you use the dataset builder in .net to build you dataset ? The tables(schema) in dataset must match exactly with the tables(schema) in your database. Make sure that first. Then create an instance of that dataset class in you project.

When you program starts, connect to the databse.

Edited by raiyan - 18 Apr 2007 at 6:49am

Hi there,

     Here is my situation. I have created a window based application with Access as the database there are 7 tables in it. I have created a deployment project in which i have included all the files (.exe .mdb). Now when i install the application in the client's m/c this database and the exe files gets copied to somewhere as per thee user's wish during install(installing location).. Let us consider the file has (i mean the dbs file , the mdb file)been copied to c:\application. when i print a report in the application it has to fetch the dbs directly from this location.

i did created a dataset and put a tables in it. i set it as the data source for my crystal report form.
but when i run it, there was an error and said that the report does not have tables. i dont understand.

please help! thanks.
Very urgent please