Hi, I tried to view more than one table fields in crystal report. But one table data ll be visible other one table data and that table header also not visible. I gave link to the two tables, but its not working fine. pls give me a simple example. Thanks in advance.

Hi,

You can also try to connect using Stored Procedure. ie., Write a query by joing the two tables inside a stored procedure and attach the stored procedure with the Crystal report. 

Here i attached my coding. i tried to write inner join expression but i'm getting error. Pls help how to solve this problem. Thanks in advance

Dim strSQL As String = "select * From OrderDetails INNER JOIN CustomerDetails ON OrderDetails.customerid=CustomerDetails.customerid" where OrderDetails.productname= '" & cboProductName.SelectedItem & "' " 

Dim DA As New OleDbDataAdapter(strSQL, conn)

Dim DS As New DataSet DA.Fill(DS, "product")

Dim cr As New ReportDocument 'cr.Load("\TestReport\TestReport\ProductwiseReport.rpt")

cr.Load("\TestReport\TestReport\Test3.rpt")

cr.SetDataSource(DS.Tables("product"))

CrystalReportViewer1.ReportSource = cr

CrystalReportViewer1.ShowGroupTreeButton = False

lvensen thanks for your post.

First you try to execute the query on your back-end and check whether all columns having the data. If its fine then put the break point in your code and check after query excuted it has data  or not.