COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mprof on 29 Jun 2014 08:15:50 AM

Title: cannot export as csv
Post by: mprof on 29 Jun 2014 08:15:50 AM
Hi,

been trying to export as csv. but can only save it as xls.
has anybody encountered this issue?

Thanks,
Mike
Title: Re: cannot export as csv
Post by: Karti on 30 Jun 2014 02:40:00 PM
I had to make this change in my Cognos environment just recently.
Read the instructions on the following link to change the format from xls/xlsx to csv when downloading the CSV file.

http://www-01.ibm.com/support/docview.wss?uid=swg21586401

There are also ways to make it delimited by different characters (tab is the default).

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id29876CSVPropertiesandValues.html

Use the above link to customize how the CSV files get generated and sent to you after exporting.

Hope this helps!