使用 Crystal Reports 8 将 3305 页报表（95000 条记录）导出到 RTF/Word/Excel 时出现问题
我在使用 CR 8 将 3305 页报告（95000 条记录）导出为 RTF 时遇到问题。
导出TXT文件时，它可以工作。
但是...
当导出大型 RTF 时，程序在导出进程进行到大约 42% 时挂起。随后它会释放系统，看起来已完成，并输出一个文件。文件本身不完整（许多记录丢失），并且格式已消失（所有内容都垂直显示，一个单词在另一个单词之上）。
我的设置是 Windows XP SP2；英特尔奔腾CPU 2.8G；大约 512 RAM.. 在另一台容量两倍的机器上，它只达到 43%。
导出大型 DOC 时，报告模块在导出过程的 63% 左右挂起。随后它释放系统并输出一个文件。该文件本身是 Word 2.0 格式的，我无法在屏幕上打开它。
Excel 8 也是一个不行
升级 CR 目前对我来说不是一个选择。
客户希望此功能发挥作用，并且目前不愿意过滤报告并以较小的块导出（他们的工作性质要求他们将其作为一个文档，在页面底部带有单个日期戳，并且其他原因。）。
看来这可能是内存问题。
我还想知道 RTF、WORD 或 EXCEL 文件的大小是否没有任何限制。我认为 EXCEL 仅适用于每个工作表 65000+ 条记录。
有什么想法吗？
PS - 我查看了与此类似的其他建议主题，但没有找到所需的答案。
我还向 Crystal Reports 发送了一封电子邮件，但我认为它们现在属于另一家公司所有，我想知道该公司是否支持版本 8。我以为我在其他地方读过，但它们不是。有谁知道谁还在支持版本8？
I'm having problems exporting a 3305 page report (95000 records) using CR 8 to RTF.
When exporting a TXT file, it works.
But...
When exporting a large RTF, the program hangs at about 42% of the export process. Later it frees up the system, appears to finish, and outputs a file. The file itself is not complete (many records missing), and the formatting is gone (everything displays vertically, one word on top of another).
My setup has Windows XP SP2; Intel Pentium CPU 2.8G; about 512 RAM.. on another machine with twice that amount it only got to 43%.
When exporting a large DOC, the Reports module hangs at about 63% of the export process. Later it frees up the system, and outputs a file. The file itself is in Word 2.0, and I cannot open it on my screen.
Excel 8 is also a no go
Upgrading CR is not an option for me at this point.
The customer wants this feature to work, and is not presently willing to filter the report and export in smaller chunks (the nature of their work requires them to have it as one single document with a single date stamp at the bottom of the page, and other reasons.).
It seems like it could be a memory issue.
I also wonder if there isn't any limits to the size of an RTF, WORD or EXCEL file. I think EXCEL is only good up to 65000+ records per worksheet.
Any ideas?
P.S. - I had a look at the other suggested topics similar to this, and did not find the answer was looking for.
I also sent an email to Crystal Reports, but I think they're now owned by another company, which I wonder is support version 8. I thought I read elsewhere they were not. Does anyone know who is still supporting version 8?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Excel（2007 年之前）至少有最大记录数，我认为是 65386 行（Excel 2007：1,048,576 行和 16,384 列）。 Word 可能存在类似的限制，但我认为这不太可能，并且这些限制是您的 Crystal 版本的导出功能的结果...
另外，我很确定您可以从 SAP（拥有 CR）获得第 8 版的支持。在我使用 Crystal Reports 的旅途中（远距离），我看到了从 CR 导出的许多问题，这些问题（最近）通过更新 ExportModeler 库进行了修正；
祝你好运，找到有关 CR8 的帮助；即使你提到升级 CR 不是一个选择，我认为这将是你唯一的资源......:(
Excel (pre-2007), at least, does have a max record count, and I think it's 65386 rows (Excel 2007: 1,048,576 rows and 16,384 columns). There may be similar limitations with Word, but I would think that's unlikely, and that the limitations are a result of the exporting functionality from your version of Crystal...
Also, I'm pretty sure you're SOL with getting support from SAP (owns CR) for version 8. In my travels working with Crystal Reports (from a distance), I've seen many issues with exporting from CR that have been (recently) corrected with updates the the ExportModeler library;
Good luck with finding some help with CR8; even though you'd mentioned upgrading CR is not an option, I think it'd be your only recourse... :(
几年前，我遇到了一个问题，水晶报表为非常大的导出生成的临时文件占用了硬盘驱动器上的所有可用空间。检查临时驱动器（通常是 C:）上有多少空间。您还可以在导出时观察磁盘空间，看看它是否占用了空间。当它几乎为零时，它会神奇地停止（例如完成 42%）。该过程失败后，临时文件将被删除，磁盘空间将恢复正常。
Years ago I had a problem where the temp file that the Crystal Report was generating for very large exports took up all the available space on the hard drive. Check to see how much space you have on you temp drive (usually C:). You can also watch the disk space as the export occurs to see if it is chewing up the space. It wil lmagically stall (e.g. 42% complete) when it gets down to almost zero. After the process fials, the temp file is deleted and you disk space goes back to normal.