I've found error in RDL, which makes columns with visible=false appear in CSV and XML files. I've found this solution to fix it
The solution is to use DataElementOutput tag. But i need to include column depends on some report parameter (boolean). So, how should i write correctly =IIF statement? I tried
but it don't work. Error is :
Deserialization failed: The 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition:DataElementOutput' element is invalid - The value '=IIF(true,Output,Auto)' is invalid according to its datatype 'String' - The Enumeration constraint failed.
What is the correct variant for IIF in tags with certain values (Output,NoOutput,Auto) ?