How to Run Report on 10g

[najm]

Following Trigger is used to run report on developer 6i if you are on the record that you want to print.

DECLARE
PL_ID paramlist;
begin
SELECT LOC INTO :GLOBAL.MP FROM KIET.MYPATH;
pl_id := Get_Parameter_List('pl_id');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('pl_id');
Add_Parameter(pl_id,'P_ENO',TEXT_PARAMETER,:STCLASS.SNO);
Add_Parameter(pl_id,'P_DEPT',TEXT_PARAMETER,:STCLASS.PID);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
run_product (Reports, :GLOBAL.MP||'SCOTT\REPORT\REPORT',synchronous, RUNTIME, FILESYSTEM, pl_id, NULL);
end;


But i want to run report on Developer 10g by the same process.
can any one tell me the procedure.


Cheers
Najm

[najm]

Dear at last i got the following trigger to run a report on Report 10g but i have a little problem which is that when i run this report it run's but in the URL window my userid, password and domain show to every one i want to hide my username/pw@host for this i use the following trigger but still i have a problem when i define report server name in this trigger

DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='http://localhost:8889/reports/rwservlet ... \reg49.rdf'
||'&desformat=pdf&destype=cache&userid=scott/tiger@orcl'
||'&paramform=yes';
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;


<u>The following error show in the new window </u>

500 Internal Server Error
org.omg.CORBA.COMM_FAILURE: vmcid: SUN minor code: 201 completed: No at com.sun.corba.se.internal.iiop.ConnectionTable.getConnection(ConnectionTable.java:148) at com.sun.corba.se.internal.iiop.ConnectionTable.getConnection(ConnectionTable.java:65) at com.sun.corba.se.internal.iiop.GIOPImpl.getConnection(GIOPImpl.java:67) at com.sun.corba.se.internal.corba.ClientDelegate.createRequest(ClientDelegate.java:652) at com.sun.corba.se.internal.corba.ClientDelegate.createRequest(ClientDelegate.java:594) at com.sun.corba.se.internal.corba.ClientDelegate.request(ClientDelegate.java:886) at org.omg.CORBA.portable.ObjectImpl._request(ObjectImpl.java:431) at oracle.reports.server._ServerClassStub.getState(_ServerClassStub.java:22) at oracle.reports.client.ServerManager.getServer(ServerManager.java:266) at oracle.reports.client.ServerManager.isSecure(ServerManager.java:373) at oracle.reports.client.ServerManager.isSecure(ServerManager.java:358) at oracle.reports.rwclient.RWClientUtility.isServerSecure(RWClientUtility.java:1055) at oracle.reports.rwclient.AuthManager.getAuthId(AuthManager.java:595) at oracle.reports.rwclient.RWClient.appendAuthId(RWClient.java:1940) at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1470) at oracle.reports.rwclient.RWClient.doGet(RWClient.java:366) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:285) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:126) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534)




Can any one guide me what is the problem




Cheers
Najm

[ahmadbilal]

Rather then using triggers just change in formsweb.cfg i have done it in DS9i i hope will work for DS10G



# ********************************
# NAMED CONFIGURATIONS
# ********************************
#
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change. The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form. For example, to use the sepwin configuration, your could issue
# a URL like "http://myhost.mydomain.com/servlet/f90s ... fig=sepwin".
#

#
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
#


<span id='hl' style='background-color: yellow'><b>This Line will display to users</b>
<b>http://lgs.logsol.com:8888/forms90/f90s ... </b></span id='hl'>

[reptest]
http://lgs.logsol.com:8888/forms90/f90s ... RENDER=YES
#http://lgs.logsol.com:8888/forms90/f90s ... RENDER=YES

[najm]

i want to run a <b>Report.</b> with blank URL.