Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Significant Performance Difference: Designer Fast; ASP.net Viewer Very Slow

<pre>

I'm in the process of evaluation of CR2008 (and its runtime).

I'd appreciate if someone could shed some light on this problem:

I create a very simple report in the designer tied to a SQL Server 2005 view.

Nothing fancy. Just a lot of records: ~400,000

I preview it in the designer: initial page shows up after only 10 seconds,

it takes another 20 seconds to fully paginate all pages.

Navigation from page to page is split second.

I load the same report, same database in ASP.net on the same machine

(I even tried on different machines connecting to different databases).

Initial page appears in about 30 seconds. Navigation from page to page takes about 15 seconds.

I am baffled by this. Below I have listed all my settings and everything else i could find.

If i get anywhere near the designer performance, then I'd be very happy.

The ASP.Net page is built based on the samples and documentation provided on BO's web site.

Thanks

Jeff

Info:

Tools: Crystal Reports 2008 downloaded from the web site: 12.0.0.683

Visual Studio 2008 SP1

SQL Server 2005 Express (and I have tried it on the full version as well)

Data Access: OLEDB

ASX page:

protected override void OnInit(EventArgs e)

{

reportDoc = new ReportDocument();

reportDoc.Load(Server.MapPath("myreport.rpt"));

SqlConnectionStringBuilder sb =

new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

ConnectionInfo connection = new ConnectionInfo();

connection.DatabaseName = sb.InitialCatalog;

connection.ServerName = sb.DataSource;

connection.IntegratedSecurity = sb.IntegratedSecurity;

if (!sb.IntegratedSecurity)

{

connection.UserID = sb.UserID;

connection.Password = sb.Password;

}

TableLogOnInfo logonInfo = new TableLogOnInfo();

logonInfo.ConnectionInfo = connection;

foreach (CrystalDecisions.CrystalReports.Engine.Table table in reportDoc.Database.Tables)

{

table.ApplyLogOnInfo(logonInfo);

}

ReportViewer.ReportSource = reportDoc;

base.OnInit(e);

}

protected override void OnUnload(EventArgs e)

{

reportDoc.Close();

reportDoc.Dispose();

base.OnUnload(e);

}

The CR Control:

&lt;%@ Register assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="cr" %&gt;

&lt;cr:CrystalReportViewer ID="crystalReportViewer" runat="server"

EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False"

GroupTreeImagesFolderUrl="" HasCrystalLogo="False" HasDrillUpButton="False"

HasPrintButton="False" HasSearchButton="False" HasZoomFactorList="False"

Height="1158px" ToolbarImagesFolderUrl=""

ToolPanelWidth="200px" Width="1059px" ShowAllPageIds="True"

ToolPanelView="None" HasToggleParameterPanelButton="False"

HasDrilldownTabs="False" HasToggleGroupTreeButton="False" /&gt;

Relevant web.config parts:

&lt;add key="CrystalImageCleaner-AutoStart" value="true" /&gt;

&lt;add key="CrystalImageCleaner-Sleep" value="60000" /&gt;

&lt;add key="CrystalImageCleaner-Age" value="120000" /&gt;

&lt;compilation debug="true"&gt;

&lt;assemblies&gt;

&lt;add assembly="System.Core, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=B77A5C561934E089"/&gt;

&lt;add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=31BF3856AD364E35"/&gt;

&lt;add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=B77A5C561934E089" /&gt;

&lt;add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=12.0.1100.0,

Culture=neutral, PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=12.0.1100.0,

Culture=neutral, PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=12.0.1100.0,

Culture=neutral, PublicKeyToken=692FBEA5521E1304"/&gt;

&lt;add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/&gt;

&lt;/assemblies&gt;

&lt;buildProviders&gt;

&lt;add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider,

CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral,

PublicKeyToken=692fbea5521e1304"/&gt;

</pre>

Former Member
Not what you were looking for? View more on this topic or Ask a question