hi,

i am creating a dataset from different tables data at runtime. and i want to set this to my crystal report, but it is not working properly. i am posting my code, please go through it.

strSQL = "SQL Query String to Select data from different tables using InnerJoin "
SQLCNN = "my data connection string"

Dim cmd As New SqlCommand(strSQL, SQLCNN)
Dim DA As New SqlDataAdapter(cmd)
Dim DS As New DataSet

DA.Fill(DS)

rptDocument.Load(strReportName)
rptDocument.SetDataSource(DS)
rptDocument.Refresh()
crViewer.ReportSource = rptDocument
crViewer.RefreshReport()

In my dataset i am getting the desired records, but in report it is showing the records generated at design time

Please advise, where i am wrong.

thanks in advance

I am using OLE DB Provider for SQL Server for crystal report. and crystal report version is 2008. Visual Studio 2008.

In my VB.net code i am using ADO.net for connection. My real problem is, if am selecting data for the report from one table only, then the above code will work, if it is more than one table report is showing the records that is showing at the time of creating the table. So i specified the table names in "setdatasource" method then then issue is - records are duplicating.... what can be the reason? Please help me....

if required i an post more code details