导出CSV时不希望显示标题 [英] Don't want titles to show when exporting to CSV
本文介绍了导出CSV时不希望显示标题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我不希望在将报告导出为CSV时显示标题。
我删除了标题但仍然显示标题(它们不在Excel中显示,但在CSV中显示)。
I don't want titles to show when I'm exporting a report to CSV.
I removed the title but still titles are showing (They are not showing in Excel, but in CSV they are).
请参阅附加的打印屏幕
See Attached print Screens
推荐答案
Hello Thomas,
您的要求可以通过以下步骤来实现: />
1)创建另一行显示列名称,这样您的报告应该有2行用于列标题
2)使用全局变量隐藏visibity Globals!RenderFormat.IsInteractive,它给出一个布尔值,指示当前呈现请求是否使用交互格式。
3) 设置第一行列标题的可见性为
= IIF(Globals!RenderFormat.IsInteractive = 1,TRUE,FALSE)
4) 设置第二行列标题的可见性为
= IIF(Globals!RenderFormat.IsInteractive = 1,FALSE,TRUE)
谢谢,
Vishal Jharwade
Hello Thomas,
Your requirement can be achieve by following steps:
1) Create another row which displays column Name so your report should have 2 rows for column Headers
2) Hide the visibity by using global variable Globals!RenderFormat.IsInteractive which gives a boolean that indicates whether the current rendering request uses an interactive format.
3) Set the visbility for first row of column Header
=IIF(Globals!RenderFormat.IsInteractive=1,TRUE,FALSE)
4) Set the visbility for second row of column Header
=IIF(Globals!RenderFormat.IsInteractive=1,FALSE,TRUE)
Thanks,
Vishal Jharwade
这篇关于导出CSV时不希望显示标题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文