Report 10g in Web Browser [message #85328] |
Wed, 16 June 2004 02:55 |
hudo
Messages: 165 Registered: May 2004
|
Senior Member |
|
|
Hello,
I used to develop with Forms 6i, now I'm using Forms 10g (from Oracle Developer Suite 10g).
By pressing a button within a form, I'd liked to see the respective report in the webbrowser.
Here is the code how it was implemented with Forms 6i:
--------------------------------------------------------
PROCEDURE call_rep_datesearch IS
para_id_form PARAMLIST;
para_id_rep PARAMLIST;
--p_sessionid NUMBER;
BEGIN
para_id_rep := GET_PARAMETER_LIST('ein_param');
--
IF NOT ID_NULL(para_id_rep) THEN
DESTROY_PARAMETER_LIST(para_id_rep);
END IF;
--
para_id_rep := CREATE_PARAMETER_LIST('ein_param');
ADD_PARAMETER(para_id_rep,'p_starttime',TEXT_PARAMETER,TO_CHAR(:SEARCHFIELD.STARTDATE,'dd.mm.yyyy'));
ADD_PARAMETER(para_id_rep,'p_endtime',TEXT_PARAMETER,TO_CHAR(:SEARCHFIELD.ENDDATE,'dd.mm.yyyy'));
-- Ask for parameters: NO oder YES
ADD_PARAMETER(para_id_rep,'PARAMFORM',TEXT_PARAMETER,'NO');
-- ADD_PARAMETER(para_id_rep,'PARAMFORM',TEXT_PARAMETER,'YES');
RUN_PRODUCT(REPORTS,
'rep_datesearch.rep',
SYNCHRONOUS, RUNTIME,FILESYSTEM ,para_id_rep, NULL);
--DELETE REPORT_TABLE WHERE id = p_sessionid;
--FORMS_DDL('COMMIT');
NULL;
END call_rep_datesearch;
---------------------------------------------------
What has to be changed ?
|
|
|
Re: Report 10g in Web Browser [message #85334 is a reply to message #85328] |
Wed, 16 June 2004 07:00 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Hi,
I am not sure if RUN_PRODUCT is supported in 10G, so you must try it out.
Otherwise make use of either RUN_REPORT_OBJECT or WEB.SHOW_DOCUMENT built-ins.
HTH
Regards
Himanshu
|
|
|
|
|