I really have a big problem with crystal XI. When i write code setdatasource from .net to crystal XI , it really slow to set .... i don't know why.
Dim DA As New SqlDataAdapter("SELECT * FROM REGISTER_PAYMENT
order by invno", GCnn)
Dim DS As New DataSet
Dim RPT As New RptSaleRegisterwithPayment
Try
DA.Fill(DS)
If DS.Tables(0).Rows.Count = 0 Then
Dim MSG As New FrmMessageOK
MSG.LBLENG.Text = "No Invoice Transaction!"
MSG.ShowDialog()
Me.Cursor = Cursors.Default
Exit Sub
End If
RPT.SetDataSource(DS.Tables(0)) ' it is very slow when i this statement
RPT.SetParameterValue("DATE", "FROM " & Format(cash_in, "dd-MM-yyyy hh:mm tt") & " TO " & Format(Now, "dd-MM-yyyy hh:mm tt"))
showREPORT(RPT)
RPT.Close()
RPT.Dispose()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Have anybody can help me ?
i hope to hear a best solution soon...
thank you for everyone who read my problem.