Exporting a paginated report into Excel

[Markzolotoy]

The users are asking to make a few columns hidden when a report is exported into Excel. Is it even possible?

Thanks

[bradsy]

On column visibility, try something like: =IIF(Globals!RenderFormat.Name = "EXCELOPENXML", true, false)

[Markzolotoy]

That will remove columns in Excel export because the expression is whether to hide.

[bradsy]

Ah, you want excel hidden, not tablix hidden. I know of no way to do that.