COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jasp on 10 Feb 2012 01:03:27 PM

Title: Saving Reort / Excel to directory
Post by: jasp on 10 Feb 2012 01:03:27 PM
Hi there,

does any one know when setting a report to run via the scheduler in Cognos is there any way to have the report saved to the network i.e have the report run (excel format) and automatically saved to a pre determined network path, so that another user can pick up this file.

I have looked at the options in the schedule and all that is available is the ability to send the report via email.

Any help would be greatly appreciated. Thanks.
Title: Re: Saving Reort / Excel to directory
Post by: tjohnson3050 on 10 Feb 2012 08:40:42 PM
There is a way, but you need to set it up in Cognos Configuration on the Server (global configuration).  The network location must be visible to account used to start the Cognos BI service.   That defines the root directory, then in Cognos Administration, you need to define a name that will be used.  After that, when running a report with options, or from the scheduler, a new option will appear under save the report that will say 'save to a network location'.  You will not be able to browse to a location, but you will be able to choose a the named location you defined previously.