strange behavior while exporting SSRS report to CSV

  • I have a report with Parameter filter on top , design view has two tablix H1 and H2 when I run the report

    I chose the parameter H1 or H2 and based on my selection report return data showing tablix H1 or tablix H2. after the report is rendered I export the report csv but regardless of what report I ran H1 or H2 it will always export H1 tablix to csv. see attached screen shot for report preview

    Thanks

  • A lot of functionality of SSRS is ignored when exported to CSV.

    Exporting to a CSV File

    How did you implement the switch between the two tablixes? The interactivity section in the mentioned article says show/hide is ignored.

    Maybe you can try an implementation with subreports?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I have a Parameter which has two Values H1 and H2 and then in tablix properties visibility section I have choose show and hide based on expression and set up this based on Tablix =Parameters!H1.Value = "H1"

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

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