Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
3 years ago

Exporting a paginated report into Excel

The users are asking to make a few columns hidden when a report is exported into Excel. Is it even possible?   Thanks
Need Help
bradsy's avatar
bradsy
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
3 years ago

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

  • bradsy's avatar
    bradsy
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

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