导出到 Excel 时如何消除空白行? [英] How to eliminate blank rows while exporting to Excel?

问题描述

当我将水晶报表导出到 Excel 文件时，它会在每个详细信息行之后添加一个空白行.我尝试了许多解决方案，例如对齐字段、保持高度相似、对齐为基线.但它们都不起作用.

When I export a crystal report to an Excel file, it adds a blank row after every detail row. I have tried many solutions like aligning the fields, keeping the height similar, alignment as baseline. But none of them work.

能否请您告诉我一个解决方案，以免添加此类空白行?

Can you please let me know a solution so that such blank rows don't get added?

推荐答案

最后，我通过试错法得到了解决方案.在水晶报表设计器上，我去了报表->部分专家.在详细信息部分下，取消选中自由格式放置"复选框并单击确定".此解决方案有效，并且在导出到 excel 时不再出现空白行.

Finally, I got a solution with trial and error method. On crystal report designer, I went to Report->Section Expert. Under Details section, unchecked the 'Free-form Placement' checkbox and clicked on 'OK'. This solution worked and the blank rows no longer appeared while exporting to excel.

这篇关于导出到 Excel 时如何消除空白行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！