从reportviewer导出到PDF花了太多时间晶体报告基本10.5 [英] Export to PDF from reportviewer took too much time crystal report basic 10.5

问题描述

我正在使用VS2008附带的基本10.5的水晶报告。我有近4000页的大量报道。当我将ReportViewer的报告导出为PDF或单词时，导出该报告花了将近3个小时。我们使用视图绑定报表，并通过报表设计中的记录选择公式指定过滤条件。我们在asp.net 3.5中使用web应用程序。



我应该怎样做才能提高报告性能？



代码，结构或任何硬件改进的任何变化？



如果您有疑问请随时告诉我。

任何我们将不胜感激。



问候，



Azhar Iqbal

I am using crystal reports basic 10.5 that are shipped with VS2008. I have some huge reports of almost 4000 pages. When I export report from ReportViewer to PDF or word then it took almost 3 hours to export that report. We are binding reports with views and assigning filter criteria by record selection formula in report design. We are using web application in asp.net 3.5.

What should I do to improve report performance?

Any change in code,structure or any Hardware improvement ?

Please if you have query then Please do let me know.
Any immediate help would be appreciated.

Regards,

Azhar Iqbal

推荐答案

这里有一些关于双方表现的建议



数据库方面

在SQL Server中优化数据访问的十大步骤：第一部分（使用索引） [ ^ ]

在SQL Server中优化数据访问的十大步骤：第二部分（重新考虑TSQL和a pply最佳做法） [ ^ ]

在SQL Server中优化数据访问的十大步骤：第三部分（应用高级索引和非规范化） [ ^ ]

优化SQL Server中数据访问的十大步骤：第四部分（诊断数据库性能问题） [ ^ ]

优化SQL Server中数据访问的十大步骤：第五部分（优化数据库文件并应用分区） [ ^ ]



Crystal报告方

报告分析器：优化Crystal Reports [ ^ ]

优化报告性能 [ ^ ]

优化Crystal Reports [ ^ ]

Crystal Reports使用.NET C＃（SetDataSource）缓慢加载 [ ^ ]



希望这些能帮到你。

Here some suggestions regarding the performance on both sides

Database side
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]

Crystal reports side
Report Analyzer: Optimize Crystal Reports[^]
Optimizing Report Performance[^]
Optimizing Crystal Reports[^]
Crystal Reports Slow Load Using .NET C# ( SetDataSource )[^]

Hope these will help you.

这篇关于从reportviewer导出到PDF花了太多时间晶体报告基本10.5的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！