I-BEGO

Malam Para Master
master kenapa di program saya tidak tampil report di crystal report. padahal datanya ada. apa yang salah dengan coding saya.:
ini coding saya

Code: Select all

dttable = New DataTable
        sql = "SELECT * FROM ms_dipem "
        cmd = New MySqlCommand(sql, koneksii)
        cmd.Connection = koneksii
        koneksii.Open()
        Try
            '     DTadapter.Fill(dttable)
            objRep = New rptdipem
            objRep.SetDataSource(dttable)
            CrystalReportViewer1.ReportSource = objRep
            dttable.Dispose()
            cmd.Dispose()
            koneksii.Close()
        Catch ex As Exception
            MessageBox.Show("error", ex.Message)
        End Try

preview CRnya saya lihat ga ada. kalo di xtrareport urutannya kan seperti ini :

SQL = SQL "Select .........."
Dim ds As DataSet = New DataSet()
CheckConnection()
Dim SqlDbDataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(SQL, SQLConn)
SqlDbDataAdapter.Fill(ds, "Mahasiswa")
Dim dvManager As DataViewManager = New DataViewManager(ds)
Dim dv As DataView = dvManager.CreateDataView(ds.Tables("Mahasiswa"))

Dim Report As New ReportGL

Report.DataSource = dv
Report.XSourceType.DataBindings.Add("Text", dv, "NIK")
Report.ShowPreviewDialog()

SQLConn.Close()


Sorry soalnya aku ga pake CR di VB.NET. mungkin bisa menjadi bahan referensi.