CSV output from scheduled job

[BigChris]

Hi - I've got something weird going on that just doesn't make sense to me. I've got a client that needs his reports to come to him in .csv format every day. No problem, the reports are set up and the job was created in Cognos10. The job ran successfully and sent the reports in the right format. Since we've upgraded to 11.1.1 the reports are being sent in HTML format. Now, the particularly weird bit; when I run the job manually (unchanged) it sends the reports in .csv format

Has anyone got any suggestions for things to check? Are there any settings that spring to mind that might cause that behaviour? As a short term fix I can run the job manually, but given that that means getting up at 4:30 that's something I want to fix sooner rather than later.

[MFGF]

Hi - I've got something weird going on that just doesn't make sense to me. I've got a client that needs his reports to come to him in .csv format every day. No problem, the reports are set up and the job was created in Cognos10. The job ran successfully and sent the reports in the right format. Since we've upgraded to 11.1.1 the reports are being sent in HTML format. Now, the particularly weird bit; when I run the job manually (unchanged) it sends the reports in .csv format

Has anyone got any suggestions for things to check? Are there any settings that spring to mind that might cause that behaviour? As a short term fix I can run the job manually, but given that that means getting up at 4:30 that's something I want to fix sooner rather than later.

Hi Chris,

Have you checked with IBM to see if this is something broken in 11.1.1?

Just a thought...

MF.

Oh. Edit. Another thought. Is this a report using a chart or crosstab and it is master-detailed inside a list? You can't burst these to csv sadly:

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_bursting_reports.html

[BigChris]

Thanks - I'll drop them a line and see if I can find anything out.

I'd understand it if the schedule NEVER sent the reports in CSV format. The fact that it'll behave itself if I run it manually is just frying my frontal cortex!

[MFGF]

Thanks - I'll drop them a line and see if I can find anything out.

I'd understand it if the schedule NEVER sent the reports in CSV format. The fact that it'll behave itself if I run it manually is just frying my frontal cortex!

So your report isn't a chart or crosstab master/detailed inside something else (eg a list)? No point in logging a call if so...

MF.

[BigChris]

It's a relatively simple list report. I'll do some more digging and see what I can find out.