以CSV格式导出时隐藏列 [英] Hide column while Export in CSV format

问题描述

大家好，


我在某些情况下使隐藏列处于工作状态，当我导出数据时，该隐藏列可以正常显示.


请给我建议.


我已经应用了解决方案，
在该colunm隐藏属性上将表达式设置为"= IIF((Globals！RenderFormat.Name =" CSV)，true，false)"

但它没有用...


请紧急帮助我..

hello all,


I have hide column in some condition it working fine nut when i export data that time this hidden column get display ...


Please suggest me..


I have applied solution that,
on that colunm Hidden property set expression as "=IIF((Globals!RenderFormat.Name = "CSV"),true,false)"

but its not worked...


please help me its urgent..

推荐答案

您不能使用表达式隐藏或省略导出列.这是因为表达式将仅在报表本身中求值，而不在导出中求值.

//一种解决方法是默认情况下隐藏列，并使用表达式显示所有其他列.//

抱歉，上述声明没有任何意义.看来您需要做的是创建一个参数，该参数将显示要隐藏或显示的列，然后在报表运行时仅不显示这些列中的任何数据.您还可以根据这些参数更改列标题的值.

唯一的另一种选择是使用不同的列组合创建尽可能多的报告，然后动态加载正确的报告.


好的，想念小姐...

You cannot hide or omit columns for the export, using expressions. This is because the expressions will only get evaluated in the report itself, not the export.

//a workaround would be to hide the columns by default and show all others using the expression.//

my apologies, that above statement made no sense. It seems what you will have to do is make a parameter that will show which columns to hide or display, then when the report runs just don''t display any data in those columns. You can also change the value of the column heading based on these parameters.

The only other option is to create as many reports with the different column combinations then load the correct one dynamically.


ok miss desale...

这篇关于以CSV格式导出时隐藏列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！