| report server not running [message #165972] |
Mon, 03 April 2006 16:05  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
hi all
plz someone help me
i'm using forms and report 10g
i have create form to open report test_rep.rdf in paper layout
i'm using run_report_object built_in
i found file rep_"pcname".conf as server name configuration file
but when i'm using rep_"pcname" as server name in run_report_object built_in
error raised : cannot connect to server rep_"pcname"
also when i trying to insall report server by execute rwserver.exe using command " rwserver -intall <server_name> message " please consult the installation guide"
plz help me it's very urgent
i don't want to use web.show_document
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: report server not running [message #166573 is a reply to message #166483] |
Fri, 07 April 2006 00:56  |
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
|
Member |
|
|
I check ur Forms & report...
Here is something missing
If you are not connecting to the report server then must run this URL
http://Ahmad.amtextile.com:8889/reports/rwservlet
http://Ahmad.amtextile.com:8889/reports/rwservlet/showjobs
This URL Intialize the report server as run_report_object can't start automatically when you restart the system. but this policy is implemented on server which never shut down.
2ndly you must append some code at the last of your when button pressed...
ur Exact Code will work like this :
-----------------------------
declare
report_id Report_Object;
P_LIST_ID PARAMLIST;
ReportServerJob VARCHAR2(100);
REPORT_STATUS VARCHAR2(100);
-- REPORTSERVERJOB VARCHAR2(100);
JOB_ID VARCHAR2(100);
BEGIN
P_LIST_ID := GET_Parameter_List('PLIST');
report_id:= find_report_object('emp');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'rep_pchtalaat');
(No need of it coz report has no parameter.Oterwise in report u must define a userparameter name as p_deptno which is then refer from this parameter below)
--SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'p_deptno='||:emp.Deptno||'paramform=no');
ReportServerJob:=run_report_object(report_id);
(if report has parameter then run this statement with parameter llist)
--REPORTSERVERJOB := RUN_REPORT_OBJECT(REPORT_ID,P_LIST_ID);
JOB_ID := SUBSTR(REPORTSERVERJOB,LENGTH('rep_pchtalaat')+2,LENGTH(REPORTSERVERJOB));
REPORT_STATUS := REPORT_OBJECT_STATUS(REPORTSERVERJOB);
IF REPORT_STATUS = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid' || JOB_ID || '?server=' || 'rep_pchtalaat', '_blank');
END IF;
END;
I m sending you this piece of code after checking and this is working.
Regards,
Ahmad
-
Attachment: emp.fmb
(Size: 48.00KB, Downloaded 1471 times)
[Updated on: Fri, 07 April 2006 00:57] Report message to a moderator |
|
|
|
| Re: report server not running [message #166821 is a reply to message #165972] |
Sun, 09 April 2006 11:31 |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
error " unable to run report" raised
when i'm trying to use URL you have wrote no page displayed
i replaced the name of the server you wrote with my server name "rep_pchtalaat" but nothing displayed and the same error " unable to run report FRM- 41214"
|
|
|
|
| Re: report server not running [message #223803 is a reply to message #165972] |
Sun, 11 March 2007 13:12 |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
the problem solved
the attached doc is for "how to use run_report_object"
about server name
i write a query to get "terminal name " for the current session
and create report name " rep_treminal name_oracle home name"
you can also create a new report server as following
1- rename the file rep_hostname.conf to the name you want .
2- execute RWSERVER server ="newname"
the new servername.dat file will created .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
