Export to CSV is showing hidden columns for Vertica data RRS feed

  • Question

  • Hi,

    I am using HP vertica Database in my report. My requirement is based on the no of columns passed in the parameter, I need to show or hide the columns. When we hide the columns in the column visibility expression, in the report display it is hiding but when we export the same report to CSV, it is still showing the hidden columns.

    Even the below statement in the Column visibility expression is not working with Vertica database which is working for other databases (SQLServer, Oracle)

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

    When we make DataElementOutput to NoOutput, Column is hiding but my requirement is based on the expression value, I need to show or hide.

    Please help.

    Thanks in advance.


    Ramesh M

    Friday, August 22, 2014 9:55 AM