hi all,
I wondering, how to save report studio reports locally. For example i have a report called sales in report studio. I want to save this in C:\sales.pdf automatically with scheduler....and can we save report design and specification also ..? is this possible..?
Thanks in advance
Hi,
You can configure the C8 Content Manager to save report outputs to a folder on-disk instead of saving them back to the content store, but it's an all-or-nothing approach for the entire C8 installation. To do this, you need to enable the 'Save Report Outputs to a Filesystem' option in the Content Manager section in Cognos Configuration, then from a web browser, go into the Server Administration utility, into the properties of your Content Manager Service, edit the Advanced Settings and set a parameter called CMOUTPUTLOCATION to point to the folder you want your outputs saving into. Also be aware that the saved outputs do not have friendly names, so you will probably need to invent some sort of process to rename them once they have been saved.
Saving report specifications locally can also be done, but only from Report Studio. To enable this option, first you need to register the lfa.dll (regsvr32 lfa.dll) then go into Report Studio, into Tools/Options, and check the 'Allow Local File Access' option. This will add 'Save Local' and 'Open Local' options into the file menu in Report Studio.
Best regards,
MF.
Thanks a lot MFGF. Appreciate your detailed explaination.
Quote from: MFGF on 20 Sep 2007 02:04:26 AM
Hi,
You can configure the C8 Content Manager to save report outputs to a folder on-disk instead of saving them back to the content store, but it's an all-or-nothing approach for the entire C8 installation. To do this, you need to enable the 'Save Report Outputs to a Filesystem' option in the Content Manager section in Cognos Configuration, then from a web browser, go into the Server Administration utility, into the properties of your Content Manager Service, edit the Advanced Settings and set a parameter called CMOUTPUTLOCATION to point to the folder you want your outputs saving into. Also be aware that the saved outputs do not have friendly names, so you will probably need to invent some sort of process to rename them once they have been saved.
Saving report specifications locally can also be done, but only from Report Studio. To enable this option, first you need to register the lfa.dll (regsvr32 lfa.dll) then go into Report Studio, into Tools/Options, and check the 'Allow Local File Access' option. This will add 'Save Local' and 'Open Local' options into the file menu in Report Studio.
Best regards,
MF.
There is an utility from cognos supportlink which makes creating friendly names easier.
http://support.cognos.com/supported/tti/public/index.html
once you have logged into the support, under documents library>select a category choose
Development then under the sub menu expand Utilities
look for
Output Processor Package for Cognos 8 you will also find another version Java app for reportnet
This article piqued my interest regarding saving the report specs to the local file system. I did run across an issue where, after following the two steps to allow local file access, it still didn't work. The problem was security settings in Internet Explorer. I had to enable/prompt for "Initialize and script ActiveX controls not marked as safe for scripting". I chose to prompt, as I'm not a proponent of allowing everything, especially "ActiveX controls NOT marked as safe..." free reign on my system.
This sure makes saving report specs much easier than having to copy to clipboard and paste to notepad or whatever editor you use.
Thanks for the tip Pargol4 - much appreciated! :)
MF.