Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Seveman on 27 Feb 2019 03:39:57 AM

Title: Dynamically change pdf export of report name in Cognos 10.2.1
Post by: Seveman on 27 Feb 2019 03:39:57 AM
Hi,

I have a report called "Sales". This report is run once a month by a scheduled job and sent by email in PDF format. My users want to have the month of the data to be shown in the filename, for example "Sales_201901" for the January execution "Sales_201902" for february and so on.

I've looked all over to see how can I do that and so far I've seen no option to do that. Any ideas?

Thanks in advance
Title: Re: Dynamically change pdf export of report name in Cognos 10.2.1
Post by: Francis aka khayman on 12 Mar 2019 01:48:22 PM
you can't per se.

you can however save the report to a folder and run a batch file to change the filename... research on cm.outputscript

not sure if you can then email the report... you might have to ask users to copy it from that folder.
Title: Re: Dynamically change pdf export of report name in Cognos 10.2.1
Post by: CognosPaul on 13 Mar 2019 05:38:42 PM
There is a way, but it's a bit complicated, and it involves using the Browser That Shall Not Be Named (i.e. IE).

Basically you need to set up the report as a burst, and use the month key as the label.

Once the burst is set up, use the instructions from IBM here: http://www-01.ibm.com/support/docview.wss?uid=swg21966700
Text only | Text with Images