Avatar of mrcoolcoder
mrcoolcoder

asked on 

Crystal Reports 11.5 Slow using Multiple Tables from .NET environment

I am using Crystal Reports 11.5 and have a report that is slow.  I am connecting to Oracle (through ODBC(RDO)) and I have three tables that are joined in the report.  My problem is it is very slow (5-9 seconds).  I have indexes on the tables and the report runs fine in the Crystal Reports environment.  

I am using the ReportDocument object to export to PDF. I believe that Crystal is logging into each table seperately instead of just logging in once and running the query.  For some reason logging into Oracle always takes a few seconds.  I know there are lots of problems with Crystal and speed but none of them seem to be related to this problem.  My logon code is below.  If I keep everything the same and run it on SQL Server it is much faster.

Bonus points if you can show me how to change the ODBC source without having to change it in the report like I do now.
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
        myConnectionInfo.UserID = "user"
        myConnectionInfo.Password = "pwd"
 
        Dim myTables As Tables = hierarchicalGroupingReport.Database.Tables
        For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables
            Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo
            myTableLogonInfo.ConnectionInfo = myConnectionInfo
            myTable.ApplyLogOnInfo(myTableLogonInfo)
        Next

Open in new window

Crystal Reports.NET Programming

Avatar of undefined
Last Comment
mrcoolcoder

8/22/2022 - Mon