COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bvk.cognoise on 21 Nov 2011 05:25:08 AM

Title: report output file name with time satmp?
Post by: bvk.cognoise on 21 Nov 2011 05:25:08 AM

Hi ,
I have an urgent requirement could you please help in this report.

We have lot of reports. we are scheduling this report  weekly, monthly, daily basic based on requirement. but my requirement is we have a report named for eg: "sales for yesterday". this report schedules everyday and sends report output with name" sales for yesterday". but my end user requirement is he want see the "date" at the end of report output file name every time it schedules and delivers the report output.

For eg: "sales for yesterday01-11-2011"
"sales for yesterday02-11-2011"..
"sales for yesterday03-11-2011".

So that user can easily access the file which he wants based on the date. could you please help me how to achieve this requirement.

Thanks
bvk
Title: Re: report output file name with time satmp?
Post by: nmcdermaid on 21 Nov 2011 05:06:21 PM
CM.OUTPUTLOCATION and CM.OUTPUTSCRIPT are settings in you dispatcher. If you search on these terms you will find a lot of examples.

CM.OUTPUTSCRIPT points at a script that is run immediately after your file is exported. So you need to build a script (batch file, VBScript, whatever) that timestamps your output file as required.
Title: Re: report output file name with time satmp?
Post by: bvk.cognoise on 22 Nov 2011 04:02:46 AM
Hi nmcdermaid,

Thank you very much for your reply but could you please give any other solution for this.

thanks
bvk
Title: Re: report output file name with time satmp?
Post by: Pranav on 05 Jan 2012 10:36:12 PM
Did you get any solution for this issue? please post