This discussion is archived
2 Replies Latest reply: Nov 13, 2012 12:42 PM by wdavidson RSS

Forms & Reports Standalone servers and csv files.

wdavidson Newbie
Currently Being Moderated
I have a forms application that uses a remote reports server. In 10g, the forms and reports server were on the same server. In 11g architecture, they are a standalone server. One of the reports is an export into a csv file.

In the 10g code, the forms code is written to create a csv file in the reports cache directory on the local reports server and then uses webutil to send the file to client.

The problem is: In the 11g architecture, the cached file is created on on the standalone reports server and is inaccessible to the standalone forms server webutil's webutil_file_transfer.AS_To_Client_With_Progress .

The configurations I have found are:
On forms server.
1. webutil.cfg which dictates the directory access.
2. xxx.env which gives REPORTS_SERVER and REPORTS_PATH.

Of course none of this matters, because the file is on the reports server cache directory.

So my question, is there a way to generate a csv files the way the pdf reports show (web.show_document(reportserverurljobid)) . Or some sort of parameter I can pass via to the reports server to initiate a download from it.

Thanks,
wad

Edited by: 917320 on Nov 5, 2012 12:01 PM
  • 1. Re: Forms & Reports Standalone servers and csv files.
    Christian Erlinger Guru
    Currently Being Moderated
    I don't get it. How do you create the file? With forms or with reports? If it is forms then what has this to do with the reports temp directory? If it is forms why don't you use the reports object?
    Or do you generate a <jobid>.csv file in the reports cache directory and access it via
    http://ias/reports/rwservlet/getjobid121212
    ?!? (IF this even works)

    In that case why don't you declare an aliasmatch and access the file you generated via this aliasmatch:
    http://httpd.apache.org/docs/2.2/mod/mod_alias.html#aliasmatch

    cheers
  • 2. Re: Forms & Reports Standalone servers and csv files.
    wdavidson Newbie
    Currently Being Moderated
    Thanks Christian!

    Sorry for the post. It seems I started and stopped many times without reading it.

    I was able to resolve the problem by putting the export on the Forms Server side. I am not sure why the original developers invoked the reports server.

    Resolved by,
    Adding a variable in the app.env file.
    LOCAL_REPORTS_PATH=WEBUTILCACHE DIRECTORY

    Configuring the webutil.cfg to read and write to that directory.

    Thanks,
    wad

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points