llamado reporte

Upload: alexvalenciaayola

Post on 12-Oct-2015

8 views

Category:

Documents


0 download

TRANSCRIPT

DECLARE parametros Paramlist; elemento Item; BEGIN /*Buscamos el tem IDAlumno*/ elemento := Find_Item('IDalumno'); /*Creamos la lista de parmetros*/ parametros := Create_Parameter_List('Param_i'); /*Le aadimos el alumno elegido*/ Add_parameter(parametros, 'elegido', TEXT_Parameter, Get_Item_Property(elemento, DATABASE_VALUE)); /*Llamamos al informe de matricula de un alumno*/ Run_PRODUCT(REPORTS, 'Matricula', SYNCHRONOUS, RUNTIME, FILESYSTEM, parametros, NULL); /*Limpiamos la la lista de parmetros creados*/ Destroy_Parameter_List(parametros); END;PROCEDURE TEST_REPORT IS repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20);BEGIN repid := find_report_object('EMPLOYEE'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, BATCH); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, CACHE); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'html'); -- PDF, HTMLCSS ... SET_REPORT_OBJECT_PROPERTY(repid, REPORT_SERVER, 'rep_adminserver_my-pc_asinst_2'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_OTHER, 'paramform=no pdeptno=' || :department); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); WHILE rep_status IN ('RUNNING', 'OPENING_REPORT', 'ENQUEUED') LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://