Post reply

SSRS REPORT Invisible columns shown when exported to .csv

  • November 12, 2012 at 12:11 pm

    #284628

    Hi All,

    I have a SSRS report.I had used an expression in the hidden property in the tablix member. My intention is to show only those records which evaluates to 'false' for the expression.

    When i export this report to excel, everything is working is fine, i.e hidden records are not shown, but when i export this same report to .csv then hidden records are also shown.

    I had tried using =iif(Globals!RenderFormat.Name="CSV", True, False) in the hidden property and also tried changing the "DATA ELEMENT OUTPUT" from auto to output, but they didn't worked.

    Does anyone solved this problem earlier ??

  • November 13, 2012 at 8:15 am

    #1558515

    I generally use the filters rather than hidden because that explicitely excludes the row. Would that work for you?

  • November 13, 2012 at 4:13 pm

    #1558692

    Thanks for your response!! I can't use parameters in my report.

  • November 14, 2012 at 11:24 am

    #1559052

    What have parameters got to do with it. Just take whatever expression you're using for the hidden property and use it's inverse as the filter property.

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

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