Click here to Skip to main content
15,886,643 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Please Help Me,

Open Crystal Report Very Slow,
I Use CR version 13.9 in Visual Basic and C# 2012
Posted
Comments
CHill60 27-Jan-15 2:59am    
We can't see your screen, your HDD or your thoughts.
What query is being run on report open? Is a complex report that could be simplified?
We need more information before we can help you!
Deki syahputra 27-Jan-15 20:05pm    
I'm Sorry, This is My Code to Open Report :

Imports System.Data.SqlClient
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports CrystalDecisions.Windows.Forms
Imports CrystalDecisions.ReportSource

Private Sub OpenReport()
Try
Dim rpt As New CReportCARBON
Dim cmmd As New SqlCommand
Dim mycon As SqlConnection = Conn

cmmd.Connection = mycon

cmmd.CommandText = "Select * from fnReportAC('" & Format(TxtDate.Value, "yyyy-MM-dd") & "','7')"

Dim myda As New SqlClient.SqlDataAdapter()
Dim myds As New RSUPDataSet

myda.SelectCommand = cmmd

myda.Fill(myds, "dtCARBON")

rpt.SetDataSource(myds)
CRV.ReportSource = rpt
CRV.RefreshReport()

Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub

Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900