Anyway to force a report to have output as .csv

[cognosdelaware]

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

[hespora]

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.

[MFGF]

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.

[Francis aka khayman]

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

[sdf]

So you can specify the delimeter weather comma,space,pipe????

[Francis aka khayman]

yup. default will be tab if i am not mistaken.