从 Crystal Reports 导出 Excel 文件时出现问题
我在将 Crystal Reports 导出到 Excel 文件时遇到问题。
我尝试了导出 Excel 数据和导出为 Excel 文件的两种选项。当我将 Crystal Report 导出为 Excel 文件时，我无法对 Excel 文件中的任何字段进行排序。 当我将报告导出为 Excel 数据时，当我在 Excel 中打开时，标题真的很混乱。前三个标题出现在所有列的末尾——这对我来说没有任何意义。
有人知道如何更改 Visual Studio 中的导出选项吗？我在 Visual Studio 上使用 Crystal Reports，但不知道如何更改这些选项。
I am having an issue exporting Crystal Reports into an excel file.
I tried both options of exporting the Excel data AND exporting as an excel file. When i export my Crystal Report as an excel file, i cannot sort any of the fields in my excel file.
When i export the report as just the excel data, when i open in Excel, the headers are really messed up. The first three headers appear at the END of all of the columns--which doesn't make any sense to me.
Does anybody know how to change export options in Visual Studio? I am using Crystal Reports on Visual Studio and have no idea how to change any of these options.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
听起来您的报表尚未以 Excel 导出的最佳方式进行布局，并且问题不在于 Visual Studio 或导出选项。根据您的 Crystal 版本，一些提示如下：
1) 确保所有列标题的宽度和最左侧位置与其相关的数据相同。
2) 最小化列标题之间的间隙以及详细信息行之间的间隙。
除非您使用的是 CR8.5 之前的版本，否则您可能无法排序，因为导出创建了许多合并单元格 - 第 1 点和第 2 点将大大缓解这种情况。基本上，如果您要导出到 Excel，您希望报表数据的布局尽可能与 Excel 电子表格类似。
It sounds like your report has not been laid out in an optimal way for Excel export, and it's not Visual Studio or the export options that is the problem here. Depending on your version of Crystal, some tips would be :
1) Make sure all column headers are the same width and left-most position as the data they relate to.
2) Minimize gaps between column headers, and also gaps between detail rows.
Unless you're using earlier than CR8.5, it's likely you can't sort because the export has created lots of merged cells - points 1 and 2 will mitigate this substantially. Basically, if you're exporting to Excel you want your report's data to be laid out as similar to an Excel spreadsheet as possible.