COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: cognosdelaware on 14 Feb 2018 10:30:13 AM

Title: Anyway to force a report to have output as .csv
Post by: cognosdelaware on 14 Feb 2018 10:30:13 AM
Hi,

  Is there anyway to have a reports default output be csv instead of the html when it is run?

  It is an adhoc run and not a scheduled report.

Thank you
Title: Re: Anyway to force a report to have output as .csv
Post by: hespora on 16 Feb 2018 01:39:10 AM
in your user preferences, you can set a default type for *all* report executions. I'm not aware of being able to do this by report.
Title: Re: Anyway to force a report to have output as .csv
Post by: MFGF on 16 Feb 2018 04:15:56 AM
Quote from: cognosdelaware on 14 Feb 2018 10:30:13 AM
Hi,

  Is there anyway to have a reports default output be csv instead of the html when it is run?

  It is an adhoc run and not a scheduled report.

Thank you

Hi,

Find the report in Cognos Connection. Go into the properties of the report and navigate to the Report tab. Check the "Override the default report options" checkbox, and you can then set the default format for the report rendering to be "Delimited text (CSV)"

Cheers!

MF.
Title: Re: Anyway to force a report to have output as .csv
Post by: Francis aka khayman on 30 Aug 2018 09:58:38 AM
i recently encountered a "report saved as CSV" issue myself. so just for fun...

... the delimiter you get might not be the one you need. in which case some server settings have to be done... hint RSVP.CSV.DELIMITER

there are other things as well like different file extension, terminating character, etc

reply if you encountered those issues as well
Title: Re: Anyway to force a report to have output as .csv
Post by: sdf on 30 Aug 2018 11:30:09 AM
So you can specify the delimeter weather comma,space,pipe????
Title: Re: Anyway to force a report to have output as .csv
Post by: Francis aka khayman on 30 Aug 2018 11:34:09 AM
yup. default will be tab if i am not mistaken.