CODEWITHSUNDEEP
excelreporting-services
Ziil
Ziil

Reputation: 351

SSRS: Report export to excel, excluding specific columns

Is it possible with ssrs to export report to excel in such way that some of the columns will be removed? Columns should be visible in report, but when exporting to excel I would like to remove certain columns. There is possibility to hide certain columns with expression (=IIf(Globals!RenderFormat.Name Like "EXCEL", True, False))*, but when importing to excel there will be just empty column without data, but I do not need this column in excel at all. Just wondering is it somehow doable?

Upvotes: 0

Views: 701

Answers (1)

papermoon88
papermoon88

Reputation: 476

Try this-

Create two versions of your matrix, using the same dataset; one for regular use and one for excel export (less columns). Create a parameter, name = "Excel", label = "Excel version?", with value/label options Yes/No.

Set expression in the visibility options of your matrices to correspond with the Yes/No options of that parameter.

Visibility option for regular matrix, select "show or hide based on an expression":

=Parameters!Excel.Value=No

Visibility option for excel matrix, select "show or hide based on an expression":

 =Parameters!Excel.Value=Yes

Upvotes: 0

Related Questions