Hello everyone ,

I have an issue i.e, I am using crystal report(version 11 release 2) in my windows applications developed in vb.net (2005)and sql server(2005) as backend . In one of the forms i placed one reportviewer control,

crystal report taking long time for preview & print(nearly 2 minute) .
please any one help me to getout of this

Dim rpt As New CrystalReport1() 'The report you created.
        Dim myConnection As SqlConnection
        Dim MyCommand As New SqlCommand()
        Dim myDA As New SqlDataAdapter()
        Dim myDS As New Dataset1() 'The DataSet you created.

        Try

            myConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _
                                             "Initial Catalog=northwind;")
            MyCommand.Connection = myConnection
            MyCommand.CommandText = "SELECT * FROM Customers"
            MyCommand.CommandType = CommandType.Text
            myDA.SelectCommand = MyCommand

            myDA.Fill(myDS, "Customers")
            rpt.SetDataSource(myDS)
            CrystalReportViewer1.ReportSource = rpt

        Catch Excep As Exception
            MessageBox.Show(Excep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try

Advance thnx.

Thank u For your Replay .
Sir
I modified my code like this
          
             MyCommand.CommandText = "SELECT * FROM Customers where cid=10 order by cid"

But this time also same. Second Preview is coming Fast(nearly 10 seconds its took.) but My first preview taks nearly 2 minutes.
Please tell any one way to solve this Problem.
            

thank you sir.
Now i want to solve that problem for that give any solution.i can't tell to my each client to change their system configuration ,I want to increase the speed using code,any dll want to add or what want do?