If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Saving Report studio reports locally..?

Started by shri, 20 Sep 2007 12:05:53 AM

Previous topic - Next topic

shri

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

MFGF

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.
Meep!

shri

Thanks  a lot MFGF. Appreciate your detailed explaination.

praveennb

#3
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




pargol4

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.

MFGF

Thanks for the tip Pargol4 - much appreciated! :)

MF.
Meep!