crystal report main report preview shows all data needed in details section but shows only 1 row when you run the program. Im using VS2010 and SAP CR

this is the debug mode of the crystal report when you click main report preview

this is the actual running program

` Here's my code:

Private Sub btnPRINT_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPRINT.Click Dim sqlDATA As String = ""

    If TempConnection.State = ConnectionState.Closed Then
        TempConnection.Open()
    End If


    sqlDATA = "SELECT * FROM view_wedding_information where id = " & lblCLIENT_ID.Text & " order by supplier_id "


    Dim cmdDATA As MySqlCommand = New MySqlCommand(sqlDATA, TempConnection)
    cmdDATA.CommandType = CommandType.Text
    Dim dr As MySqlDataReader = cmdDATA.ExecuteReader()



    Dim dt As DataTable = New DataTable()
    dt.Load(dr)


    Dim WeddingInfoReport = New rptWEDDING_INFORMATION()

    WeddingInfoReport.SetDataSource(dt)
    frmREPORT.CRViewer.ReportSource = WeddingInfoReport
    frmREPORT.CRViewer.Refresh()

    frmREPORT.WindowState = FormWindowState.Maximized
    frmREPORT.ShowDialog()



End Sub`