| REPORT SESSION [message #89118] |
Sun, 05 October 2003 13:01  |
Imran Ahmad
Messages: 22
Registered: March 2002
|
Junior Member |
|
|
Hello
I want to call reports from form but i dont to create another session which it did in default.
Please help b/c i will not perform commit in some condition.
Waiting for response
Imran
|
|
|
|
| Re: REPORT SESSION [message #89125 is a reply to message #89118] |
Fri, 10 October 2003 06:35  |
AbdulKhaliq
Messages: 11
Registered: August 2003
|
Junior Member |
|
|
AOA Imran,
here the code u can call/run and pass a parameter to u desire report. it'll use ur current session (form session)
in case of any confusion u may ask me.
Code:
DECLARE
rep_id REPORT_OBJECT;--report object type
v_rep VARCHAR2(1000);
V_NAME VARCHAR2(255);--object return name
V_RPT VARCHAR2(100);
V_JOBID VARCHAR2(100);--numeric part of job(rep_id);
BEGIN
rep_id := FIND_REPORT_OBJECT('YARN');
set_report_object_property(rep_id,report_other,'p_documentno='||:documentno);
v_rep := RUN_REPORT_OBJECT(rep_id);
V_NAME := v_rep;
V_JOBID := SUBSTR(v_name,instr(v_name,'_')+1);--rptsrv_=7+(1)
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||V_JOBID||'?server=rptsrv'); --rptsrv is the report servername
END;
regards,
AbdulKhaliq
|
|
|
|
| Re: REPORT SESSION [message #89134 is a reply to message #89125] |
Wed, 15 October 2003 11:51 |
Imran Ahmad
Messages: 22
Registered: March 2002
|
Junior Member |
|
|
Assalam - O - Aleikum
Thanks for the reply sir but i have another problem that I am not using web but i am using client / server environment. So plz tell me how i can use it.
Hop u can understand.
Allah Hafiz
Imran Ahmed Khan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
