1 2 Previous Next 15 Replies Latest reply: Sep 28, 2013 9:41 AM by Andreas Weiden RSS

    Running a report from forms 10g with parameters ?

    salute-Salem

      hi all , db and dev 10g ,

      i am trying to run a report from within forms 10g with this code

      {code}

      declare

          ro report_object ;

          v varchar2(90) ;

      begin

          ro := find_report_object('report10') ;

          v := run_report_object(ro) ;

          set_report_object_property(ro,report_other,'p_ename='||:emp.deptno||' paramform =no') ;

       

          web.show_document('http://roma-pc:8889/reports/rwservlet/getjobid'||substr(v,instr(v,'_')+1)||'?server=roma-pc','_blank') ;

      end ;

       

      {code}

      the report is displayed without any rows . why ?

        1 2 Previous Next