IBM Support

Hide Column Titles When exporting report to CSV

Troubleshooting


Problem

Requirement is to export a list report and save it as a CSV file but without the Column Headers. The CSV is going to look at the report spec and display what is there, so even if you set the visible property to "no" or the box type to "none" it will still display the Column Header in the CSV file.

Resolving The Problem

There are two ways to accomplish this.

1) Set the Box Type to "None", run the report to Excel then save the output to CSV. (Which will work fine if you are running the report interactively)

2) Set the Source Type to "Text" and don't enter a text value (which is good if your report is scheduled).

Steps:Solution #1 -

a) Create List Report

b) Select Column Header and set Box type to "None" in the Properties Pane

c) Run the report Excel

d) Save Excel sheet as CSV file.

Solution #2 -

a) Create List Report

b) Select Column Header and set Source Type to "Text" in the Properties Pane and do not type a text value.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.1.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1039759

Document Information

Modified date:
15 June 2018

UID

swg21343023

Page Feedback