Does anyone know a method to distribute a report to a file server (on an automated basis)?Ã, We have a customer that would like to pick up a .CSV file from a file server.Ã, We'd like to schedule the report to run, and have it output the file to that location each time.
The ReportNet SDK should allow you to have that functionality. Also, a global setting on the CRN Server setting can enable this as well. The reports will then be saved to the content store as well as the location defined by you.
Doesn't anyone uses Cognos Support Talk??
Jeroen wrote:
It is possible to save the PDF output to your file system on a network drive. Currently we are generating a lot of PDF reports. I've done it by bursting the report. The process is as follows: every bursted report is written to our output location and consists of a pdf and a xml file describing the pdf. These files / filenames are passed thru a script i've written which renames the pdf to a readable name. That's it. There are a couple of steps you have to take: 1. Go to the Content Manager service in Cognos configuration. 2. Overrule the settings. 3. Add "CM.OutputLocation" value = Directory where you want your output. 4. Add "CM.OUTPUTSCRIPT" if you want the reports to be passed thru a script. Btw. If I remember correctly there is also a little script in SupportLink which does the same. Only this is written in C# and I don't know if it renames the pdf's. Why i've written a custom script: Because in our reports I set the burst key to the filename I want the pdf to be saved to. If you want more info it's described in the manuals, search for file system.
Good luck,
Jeroen
ps.
Instead of PDF change the burst output type to CSV. I haven't tried this option but I suppose it would work too..
------------------------------------
Henk is this you? It's me :D