Running Crystal From Visual Studio 2010 Performance Issues

35 Views

I have a VB.NET program that runs several routines that work fine. They access an SQL database on another machine for add , change, and deletion of records. It also has reports that use the crystal report viewer and calls a crystal report 2011 report on the same machine, accessing the same SQL server (SQL Server 2008R2) and runs it interactively. It is slow as can be when I run the report. Whether I run the application on the users windows 7 machine or on the Server 2012 it is slow to bring up the actual report.

Any suggestion on how I can speed this process up... It is a straight forward piece of code. Here it is....

Public Class frmElimReviewToday

Private Sub CrystalReportViewer1_Load(sender As System.Object, e As System.EventArgs) Handles CrystalReportViewer1.Load

Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument()

rpt.Load(\\vmhb-develop\Crystal Reports\Programming Reports\SQL Current Days Eliminations Production Report.rpt)

CrystalReportViewer1.ReportSource = rpt

rpt.SetDatabaseLogon(

"xxxx", "xxxx")

End Sub

End

Class

any suggestions are appreciated...

Jim Fulton