Post reply

exporting hidden columns in SSRS R2 in Excel

  • May 16, 2013 at 10:34 am

    #277906

    Hi there,

    Have SSRS report with 2 hidden columns that must be a part of export into Excel.

    What do i do?

    thanks much for your help!

  • May 16, 2013 at 11:02 am

    #1615917

    Hi again,

    i think i can answer my own question LOL. Just add this in "Show or Hide Based on an expression" in column property:

    =IIF(Globals!RenderFormat.Name = "EXCEL", False, True)

    not visible when you run it, but shows up when export.

    i hope someone will find it useful 🙂

  • May 17, 2013 at 11:46 am

    #1616301

    Thats a nice trick. My report readers are always coming up with crazy requirements. While I have not run into this one in particular, I will save this little tidbit for future reference when it does come up. Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply