Crystal Report In Vb.net

[~V~]

Hi all,

I m trying to create a crystal report in vb.net application.
I need to show data from 3 different tables in report.
So i added all 3 tables in Field explorer of crystal report,but i m unable to show the data in it.

For this i have tried two method:-
1>Using joning add data in a single table and set the Datasource of the report to it something like this-

Dim rpt As New CrystalReport1
rpt.SetDataSource(MyDataset.Tables(0))
Me.CrystalReportViewer1.ReportSource = rpt

2>Without joining using two tables for it like this
i)Select data from 1 table
MySqlDataAdapter.Fill(MyDataset, "Table1")
ii)Select data from 2 table
MySqlDataAdapter.Fill(MyDataset, "Table2")

iii)Select data from 3 table
MySqlDataAdapter.Fill(MyDataset, "Table3")

Dim rpt As New CrystalReport2
rpt.SetDataSource(MyDataset)
Me.CrystalReportViewer1.ReportSource = rpt

But nothing happed

Any idea would be appreciated heartly

Thanks with anticipation