Hi to all,

My code below permits the user to access tables from SQL server.

   Dim myTable As Table
   Dim myLogonInfo As TableLogOnInfo
   Dim oRpt As New ReportDocument

   ' Load  the Report
   oRpt.Load("D:\REPORTS\REPORTNAME.RPT")

   ' Set the username and password
   For Each myTable In oRpt.Database.Tables
      myLogonInfo = myTable.LogOnInfo
      myLogonInfo.ConnectionInfo.UserID = "UserID"
      myLogonInfo.ConnectionInfo.Password = "Password"
      myTable.ApplyLogOnInfo(myLogonInfo)
   Next myTable

Is there any other way? Because every time i load the report it takes about 6 to 7 seconds to load.

But if I preview the report from Crystal IDE it took only 2 seconds.

Thanks.