Home » Developer & Programmer » Reports & Discoverer » SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help
SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help [message #251737] Mon, 16 July 2007 07:23 Go to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i have developed two reports.
1st one contains fields like company_code,maxrate,minnrate,change

then am using button on report to send company_code as parameter to another report (other report will show some data on basics
of company_code)
Button Code is
-------------------------------------
procedure U_1ButtonAction is
BEGIN
DECLARE
v_tmp char(100);
begin
srw.message(1,'Initilizaing Report');
srw.run_report('report=e:/Report/child_report
batch=yes desname=sysout desformat=dfit PARAMFORM=YES P_CODE=TO_CHAR(:company_code)' );

EXCEPTION
when srw.run_report_failure then
v_tmp := srw.geterr_run;
srw.message(1000, v_tmp);
end;
END;

-----------------------------------------
where P_CODE is parameter of 2nd report.
but when i click button on 1st report error invalid value of parameter P_CODE occurs

[Updated on: Mon, 16 July 2007 23:53]

Report message to a moderator

icon14.gif  Re: SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help [message #252218 is a reply to message #251737] Wed, 18 July 2007 03:00 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

Finally i Have Done This..
Re: SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help [message #252595 is a reply to message #252218] Thu, 19 July 2007 05:56 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

srw.run_report('report=e:/Usman/Report/child_report PARAMFORM=NO P_CODE='||:company_code );

just use this(according to ur report) & u will be done.
Previous Topic: Grand Total in Discoverer Report shows zero
Next Topic: Calling Oracle Discoverer from Forms
Goto Forum:
  


Current Time: Fri Dec 09 04:13:26 CST 2016

Total time taken to generate the page: 0.10430 seconds