how to prevent hidden part of report from exporting to excel

  • in my report i have multiple tablix, and i let user decide which tabilx he want to see by using visibility options...however when user export this report to excel, it exports all the tablix..how can i make sure only the visibile one is exported

  • I've never had to do this, however the link below may help you (it was interesting looking into it however thanks 🙂 )

    http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/

    Its not quite the same as what you want to do but it may point you in the right direction

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

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

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