Hi All,

I have created a crystal report, and I passed a DataSet from a form to the report by using these codes:

Don't worry about the oDataConnections object, I know there are data on the dataset and I tried to put the dataset onto a datagrid, I can see all the data on the grid, but if I put that on a report, the report only show part of the results, there are two tables, only showed one table's result, but ignore everything on the second table, I have the object for the second table on the report, but it is just not displaying.

VB Code:
  1. Dim formCrystalReport As New frmCrystalReport
  2.         Dim formMain As Form = Me.TopLevelControl
  3.         dsRPT = New DataSet
  4.         With oDataConnections
  5.             .ConnectionString = My.Settings.FNBConnectionString
  6.             .ConnectionType = "SQL Server"
  7.             .SQLStatement = oSQL
  8.             .SelectDB()
  9.             dsRPT = .ReturnDataSet(0)
  10.         End With
  11.         oDataConnections = Nothing
  12.         oReport.SetDataSource(dsRPT.Tables(0))
  13.     End Sub

Can anyone help?

PlayKid