|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
Report 10g in Web Browser
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 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 ? |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Report 10g in Web Browser |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|