水晶报表加载时间 [英] Crystal Reports Load Time

问题描述

你好，我叫Vikash Gohil.

我有一个Web应用程序，其中使用了水晶报表.

问题是，报表需要很长时间才能加载.

我想知道哪种是加载报告的更快方法，

1)在报表中使用Direct表，然后在运行时传递登录参数，
或
2)在应用程序中创建所需数据的数据集，然后使用数据集将数据传递给报表.

即使只显示一条记录，也要花费时间.我目前正在使用如上所述的第1步方法.

为什么每次加载报告时都需要传递登录信息.
有没有一种方法我们只能执行一次.

Hello, this is Vikash Gohil.

I have a web application in which we have used crystal reports.

The Problem is, reports takes long time to load.

I want to know which is the faster way to load reports,

1) Using Direct tables in reports and then passing logon parameters at runtime,
OR
2) Creating a Dataset of required data in application and then using dataset to pass data to report.

Even to display a single record it takes time. I am currently using the step 1 approach as stated above.

Why is it that we need to pass Logon info each time the report is loaded.
Is there a way we can do this only once.

Any help would be greatly appreciated, thanks in advance.

推荐答案

我强烈建议您使用PUSH模型(使用数据集并传递给报告).

通过使用连接共享并手动限制传递到报表的记录数，可以这种方式优化性能.

另外，您也不需要面对运行时登录问题.

同样，也不必面对报表中使用的子报表的相同问题

非常重要的一个:如果数据库已更改，则无需更改报表中的任何内容. (例如:[在Pull模型中，请考虑您的数据库是SQL Server，如果您的报表是基于SQL Server连接设计的.如果将来客户端要更改为任何其他数据库(例如Oracle)，则需要在所有数据库中更改连接手动报告文件.)

I strongly recommend the PUSH model (Using Dataset & pass to the report).

The performance can be optimized in this manner by using connection sharing and manually limiting the number of records that are passed on to the report.

Also you don''t need to face the runtime logon issue.

Also don''t need to face the same issue for subreports which was used in reports

Very Important one : You don''t need to change anything in reports if your database changed. (For example: [In Pull model], Consider your database is SQL server, If your reports designed based on SQL server connection. If in future client want to change into any other database(Ex. Oracle) then you need change connection in all report files manually.)

这篇关于水晶报表加载时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！