将 SSRS 报告导出到 CSV 时出现问题
我有一个 SSRS 报告,其中很少有列以编程方式可见。报告已成功生成,但当将其导出为 CSV 时,已以编程方式处理“可见”属性的列不会导出为 CSV。
有没有解决这个问题的方法 问题?
最好的实施方式是什么 隐藏 SSRS 中列的逻辑,以便 没有问题 导出为 CSV/Excel?
I have an SSRS Report in which few columns will be made visible programmatically. The Report gets generated succesfully, but when it's exported to CSV, the columns whose "visible" attribute has been handled programmatically doesn't get exproted to CSV.
Is there a work-around for this
issue?What is the best way to implement
hide logic for columns in SSRS so
that there are no issues while
exproting to CSV/Excel?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
请参阅http://blogs.msdn.com/b/bimusings/archive/2007/02/07/reporting-services-why-aren-t-all- my-report-columns-exporting-to-csv-and-or-xml.aspx 这解释了 CSV(和 XML)是一种数据格式而不是布局格式。如果像您一样通过公式切换可见性,则它根本不会在 CSV 中呈现(即使可见性设置使其可见)。
See http://blogs.msdn.com/b/bimusings/archive/2007/02/07/reporting-services-why-aren-t-all-my-report-columns-exporting-to-csv-and-or-xml.aspx which explains that CSV (and XML) is a data format rather than a layout format. If the visibility is toggled via a formula as you're doing, it won't be rendered at all in CSV (even if the visibility setting makes it visible).