Dear Sir ,

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 You For ur Replay Sir
several thoughts.

//1) debug how long it takes to return the dataset...step though that section with f10. Just how long does the data fetching take.//
It is taking nearly 2 seconds.
2) how long does it take in SQL Server
this 1 seconds
3) how many records are returned.
only one
4) what is the report doing? anything fancy? any sub
reports or is it a straight data dump.
No fancy ,No sup report.
What is my big doubt is second time that report preview is coming too fast may be 1 to 2 seconds only.
but the first time it tokes 2 minutes.
Just i'm printing customer list thats all for that it is taking too match time please help me out of this problem