-
calling report from form
i had do a form that have 2 date parameters and i am trying to pass them to create a report that gives me the information of rooms had been booked between those dates..
but it dose not work !!
and i tried to solve the problem but i could not :(
so could you please check my code .. USING oracle 10g
Declare
PL paramlist;
d1 date;
d2 date;
Begin
d1 := :d1;
d2 := :d2;
PL:=create_parameter_List('p1');
add_parameter(PL,'d1',text_parameter,to_char(:d1));
add_parameter(PL,'d2',text_parameter,to_char(:d2));
add_parameter(PL,'PARAMFORM',text_parameter,'NO');
RUN_REPORT_OBJECT(Reports,'D:\somtting3ty\uob2009\CS395\project\formy\report.rdf',asynchronous,RunTi me,FileSystem,PL);
--Web.show_document (‘/reports/rwservlet?reptest&server=Repsrv¶mform=
--no&module=report.rdf’,’_blank’);
Destroy_Parameter_List(PL);
End;
Page generated in 1,717,386,403.61423 seconds with 10 queries