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.