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

3 Replies

  • 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.