locked
Don't want titles to show when exporting to CSV RRS feed

  • Question

  • Hi people,

    I don't want titles to show when I'm exporting a report to CSV.
    I removed the title but still titles are showing (They are not showing in Excel, but in CSV they are).

    See Attached print ScreensNo TitlesStill there when exporting in CSV

    Thursday, April 4, 2019 2:04 PM

Answers

All replies

  • Hello Thomas,

    Your requirement can be achieve by following steps:

    1) Create another row which displays column Name so your report should have 2 rows for column Headers
    2) Hide the visibity by using global variable Globals!RenderFormat.IsInteractive which gives a boolean that indicates whether the current rendering request uses an interactive format.
    3)  Set the visbility for first row of column Header
        =IIF(Globals!RenderFormat.IsInteractive=1,TRUE,FALSE)
    4)  Set the visbility for second row of column Header
        =IIF(Globals!RenderFormat.IsInteractive=1,FALSE,TRUE)

    Thanks,
    Vishal Jharwade

    • Edited by VJ123456 Thursday, April 4, 2019 3:04 PM
    • Proposed as answer by Mitarai Queen Friday, April 5, 2019 1:21 AM
    Thursday, April 4, 2019 3:04 PM
  • https://stackoverflow.com/questions/40308292/ssrs-possible-to-toggle-header-visibility-based-on-export-type-2008-r2

    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    • Proposed as answer by Mitarai Queen Friday, April 5, 2019 1:21 AM
    • Marked as answer by ThomasYaris30 Sunday, December 15, 2019 8:48 AM
    Thursday, April 4, 2019 3:09 PM