OraFAQ Forum: Forms » Passing two parameters for reprot

Home » Developer & Programmer » Forms » Passing two parameters for reprot

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Passing two parameters for reprot [message #577868]

Thu, 21 February 2013 06:10

kame
Messages: 69
Registered: July 2009

Member

racle 10g developer suite

I am running report through 10g form with one parameter it is working fine.
but I want to pass two parameters . I tried but not succeeded.

1. p_date=' || :btn.at_date
2. p_date1=' || :btn.at_date1

------- With One Parameter ------------
DECLARE 
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
 
BEGIN
 
repid := FIND_REPORT_OBJECT('REPORT1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER, 'paramform=no p_date=' || :btn.at_date);
 
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('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1) ||
  '?server=rserver' ); 
else
  message ( 'error while running reports-object '  || error_text );
  message ( ' ' );
  clear_message;
end if;
end;

With Two parameters not working

DECLARE 
QT char(1):='''';
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
 
BEGIN
 
repid := FIND_REPORT_OBJECT('REPORT1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no P_date='||QT||:btn.at_date||QT||' p_date1='||QT||:btn.at_date1||QT);
 
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('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1) ||
  '?server=rserver' ); 
else
  message ( 'error while running reports-object '  || error_text );
  message ( ' ' );
  clear_message;
end if;
end;

There is no error. showing report blank no rows.
in report builder report working .

I already checked with one parameter report working but when I use two parameters than blank report.

Report message to a moderator

Previous Topic:	Set_Block_Property
Next Topic:	how i can to built form (oracle 6i) that connect with report builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:05:33 CDT 2024