Results 1 to 3 of 3

Thread: Programmatically exporting a report to a folder

  1. #1
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default Programmatically exporting a report to a folder

    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

  2. #2
    Join Date
    Feb 2009
    Posts
    1,496

    Default Re: Programmatically exporting a report to a folder

    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

  3. #3
    Join Date
    Feb 2009
    Location
    Baiona - Spain
    Posts
    890

    Default Re: Programmatically exporting a report to a folder

    Thanks Bob.

    We are eagerly waiting for version 7. I won't ask for dates. :-)
    Pepe Guimarães
    www.moose-software.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •