Sql – SSRS 2008 Hidden Columns Should NOT Export to CSV

reporting-servicessqlsql serverssrs-2008visual-studio-2008

When I hide columns in SSRS they still appear in the CSV export.

I have to hide columns, not the entire tablix.

This is what I have tried already:
The filters in the tablix hide rows not columns.
The DataElementOutput per column can not be set using an expression.

Best Answer

Format options such as expressions on visibility are ignored for CSV rendering methods. CSV rendering methods are essentially data flows, so you can suppress elements that you don't want to include in CSV files by changing the DataElementOutput from Auto, the default value, to NoOutput.

Related Solutions

Sql-server – Select columns from result set of stored procedure

Can you split up the query? Insert the stored proc results into a table variable or a temp table. Then, select the 2 columns from the table variable.

Declare @tablevar table(col1 col1Type,..
insert into @tablevar(col1,..) exec MyStoredProc 'param1', 'param2'

SELECT col1, col2 FROM @tablevar

Sql-server – Altering a column: null to not null

First, make all current NULL values disappear:

UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULL

Then, update the table definition to disallow "NULLs":

ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL

Best Answer

Related Solutions

Sql-server – Select columns from result set of stored procedure

Sql-server – Altering a column: null to not null

Related Topic