Home » Developer & Programmer » Forms » calling report from form. (10g AS Rel2 Linux)
calling report from form. [message #431524] Tue, 17 November 2009 22:28 Go to next message
smunir362
Messages: 294
Registered: September 2007
Senior Member
I call the report(.rdf) from my form passing through..
(http://host:port/reports/rwservlet?report=myrep.rdf).

I want to call the report using only (report=repname.rdf).
Because a lot of developers are working with forms and reports and we have 4 Application servers and one database Server.

Is there any option in formsweb.cfg or related file where i define rep_server=http://host:port/reports/rwservlet? parameter and it visible in every form.....
Or any other solution.
Re: calling report from form. [message #431532 is a reply to message #431524] Tue, 17 November 2009 23:50 Go to previous messageGo to next message
calluru
Messages: 17
Registered: July 2009
Location: Austin, TX, USA
Junior Member
Hi,

Is there any reason why you are not using run_report_object to run the report?

If you want the URL to be used by all the forms why not store it in the DB?

-- Balaji
Re: calling report from form. [message #431617 is a reply to message #431524] Wed, 18 November 2009 10:02 Go to previous messageGo to next message
smunir362
Messages: 294
Registered: September 2007
Senior Member
it works for 1 As and 1 DB.
But I want 3 AS with 1 DB. Now how to handle it.
Re: calling report from form. [message #431619 is a reply to message #431617] Wed, 18 November 2009 10:12 Go to previous messageGo to next message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Either you do load balancing with the OAS Reports.

Or you create a system-information-specific table that holds
information on what report server to use.

I kinda miss the &server parameter or what it is called. The parameter that tells what report server to run upon.
Re: calling report from form. [message #431624 is a reply to message #431619] Wed, 18 November 2009 10:21 Go to previous messageGo to next message
smunir362
Messages: 294
Registered: September 2007
Senior Member
How to load balance
other option system specific table is in DB. But I have more than 1 AS so how to fix it.
Re: calling report from form. [message #431632 is a reply to message #431617] Wed, 18 November 2009 11:22 Go to previous messageGo to next message
calluru
Messages: 17
Registered: July 2009
Location: Austin, TX, USA
Junior Member
When you invoke the reports URL from forms, which forms package/command are you using?

When I do web.show_document("/url/webpage.html") it prefixes the AS specific "http://host:port" address to it. This way you don't have to worry about picking your AS.


-- Balaji
Re: calling report from form. [message #431793 is a reply to message #431632] Thu, 19 November 2009 08:52 Go to previous messageGo to next message
smunir362
Messages: 294
Registered: September 2007
Senior Member
currently I am using run_report_object.
The procedure that is given on this forum.
But I have to get data within variable from a database table
For example I have a table in DB app_param. which have column(rep_server_path,rep_server)
having data ( http://apps:7778/reports/rwservlet?,rep_apps)
It is specified only one server. I want to run the same forms application from another AS i.e. apps2.

Now how I can do it.
Re: calling report from form. [message #432728 is a reply to message #431793] Wed, 25 November 2009 23:51 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No. The procedure 'given on this forum' is 'wed.show_document'. Use it and save yourself a world of pain.

David
Re: calling report from form. [message #433941 is a reply to message #432728] Sat, 05 December 2009 06:44 Go to previous messageGo to next message
smunir362
Messages: 294
Registered: September 2007
Senior Member
I have come to know we can use report server name in cgicmd.dat file. Just define a key for all reports. This key have rep_server=server name.

But how to fix the address....
Re: calling report from form. [message #437517 is a reply to message #433941] Mon, 04 January 2010 21:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Have you researched load balancing in the 'Application Server' forum? Have you discussed your problem with your application server manager and have they told you how load balancing works and how a single server address can access multiple servers?

David
Re: calling report from form. [message #439011 is a reply to message #437517] Wed, 13 January 2010 10:54 Go to previous message
smunir362
Messages: 294
Registered: September 2007
Senior Member
Yes I finally solve my problem.Thanks a lot to all.
Previous Topic: Using OLE Controle
Next Topic: Excute Procedure When Value Is In Variable
Goto Forum:
  


Current Time: Tue Sep 27 22:56:50 CDT 2016

Total time taken to generate the page: 0.09963 seconds