Report 10g in Web Browser

[hudo]

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_CHARSEARCHFIELD.STARTDATE,'dd.mm.yyyy'));
ADD_PARAMETER(para_id_rep,'p_endtime',TEXT_PARAMETER,TO_CHARSEARCHFIELD.ENDDATE,'dd.mm.yyyy'));

-- Ask for parameters: NO or 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 ?

Note: 'rep_datesearch.rep' was in the same directory as the calling form.

 

[sem]

You should read about RUN_REPORT_OBJECT built-in as in WEB environment RUN_PRODUCT doesn't functionate appropriately. Don't miss that REPORT_OBJECT is not the same as FILE CONTANING REPORT.

Regards, Dima

http://seminihin.narod.ru

 

[HimanB]

You may also make use of WEB.SHOW_DOCUMENT.

Regards
Himanshu

 

[HimanB]

Hudo,
I think I have already repled to your query in another Forum.

Regards
Himanshu