Crystal Report Missing Values with Multiple Tables

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:

Dim formCrystalReport As New frmCrystalReport
        Dim formMain As Form = Me.TopLevelControl
        dsRPT = New DataSet
        With oDataConnections
            .ConnectionString = My.Settings.FNBConnectionString
            .ConnectionType = "SQL Server"
            .SQLStatement = oSQL
            .SelectDB()
            dsRPT = .ReturnDataSet(0)
        End With
        oDataConnections = Nothing
        oReport.SetDataSource(dsRPT.Tables(0))
    End Sub

Can anyone help?

PlayKid