需要有关Crystal Report的帮助 [英] Need help regarding Crystal Report

问题描述

亲爱的所有人，

我有大约17000行和135列的记录集，在excel中导出需要花费7-10分钟的时间.

我该如何减少时间.

请帮帮我.

Thankx

Dear All,

I have record set of around 17000 of rows, and 135 of columns, it is taking time 7-10 minutes to export in excel.

How can I minimize that time.

Please help me.

Thankx

推荐答案

最小化此时间的最佳方法是不要这样做.尝试减少列数或行数.要做的另一件事是安排运行此导出，而不是尝试立即进行导出.您甚至可以在另一台(更快的)计算机上运行此导出.最后，您可以剪切出Crystal Reports并将数据从SQL直接转储到Excel中.您可能想看一下PowerPivot之类的东西，它可以很好地处理大量数据.

您正在处理近230万个数据点.将所有这些导出到Excel需要花费时间，特别是如果您一次将其加载到内存中(在Crystal中)，然后尝试在内存中进行复制以将其转换为Excel.

更新
如果您想查找有关PowerPivot的更多信息，那么这是一个不错的起点:

http://technet.microsoft.com/en-us/library/gg413497 (v = sql.105).aspx [

The best way to minimize this time would be to not do it this way. Try reducing the number of columns or rows. The other thing to do would be to schedule this export to be run instead of trying to do it on the fly. You could even run this export on a different (faster) machine. Finally, you could cut out Crystal Reports and dump the data from SQL directly into Excel. You might want to look at something like PowerPivot, which works very well with massive amounts of data.

You are working with almost 2.3 million data points. Exporting all of those into Excel is going to take time, especially if you are loading it in memory once (in Crystal) and then trying to make a copy of it in memory to transform it into Excel.

Update
If you are looking to find out more information about PowerPivot, this is a good place to start:

http://technet.microsoft.com/en-us/library/gg413497(v=sql.105).aspx[^]

It will be a radical shift from what you are doing now, but the performance improvements will be incredible. It all depends on if you want to tweak your system or if you want to do a complete overhaul. This method is a complete overhaul. The other methods above are more tweaks.

这篇关于需要有关Crystal Report的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！