Hi,
is there a way to programmatically export a report to an Excel format to a folder rather than sending it by e-mail?
TIA
Regards
Pepe
Hi,
is there a way to programmatically export a report to an Excel format to a folder rather than sending it by e-mail?
TIA
Regards
Pepe
Pepe Guimarães
www.moose-software.com
Hi Pepe,
Yes, there is.
If you execute the report via a URL and pass the device and destination parameters it should output the data to the folder specified in system setup as the Outfolder for server-side export files. It won't work for PDF, but at some time in the past I tested successfully with CSV output. Should also work with HTML. Of course out folder must have permissions set to allow the application pool user to write files there.
&DEVICE=CSV&DEST=SERVER
Perhaps an unwanted side effect you will have to figure out how to deal with is that a browser window will open just as expected for any such report execution via a URL -- except it will be blank since output was redirected to a file instead of to the browser.
You won't be surprised if I tell you version 7 will let you do this far more gracefully and many other "command line" types of operations....just don't ask me for dates....
Happy New Year,
Bob
Thanks Bob.
We are eagerly waiting for version 7. I won't ask for dates. :-)
Pepe Guimarães
www.moose-software.com