Home » Developer & Programmer » Reports & Discoverer » global variable
global variable [message #215014] Thu, 18 January 2007 22:46 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Hi... I have created a paramter list in forms and assigned it a global variable value.. My question is Can I read this variable in before / after paramter form trigger in Reports6i. I want to print this value in report.
Plz help anyone..

Thanks


declare
	cr_param paramlist;
	abc number;
begin

select balance into abc from balance_view where id=:customers.customer_id;

:global.my_var:=abc;
--clear_message();
--message('old balance Before parameter'||:global.my_var);



if :sale.card_id is null then
	message('No Transcation');
	--message('No Transcation');
else
	


 cr_param := create_parameter_list('CREATEP');

add_parameter(cr_param,'check_pass',text_parameter, :sale.customer_id);
add_parameter(cr_param,'date_pass',text_parameter, :sale.sale_date);
add_parameter(cr_param,'sale_id_pass',text_parameter, :sale.sale_id);
add_parameter(cr_param,'old_bal_pass',text_parameter, :global.my_var);
add_parameter(cr_param,'PARAMFORM',text_parameter, 'NO');
add_parameter(cr_param,'MAXIMIZE',text_parameter, 'YES');
-- add_parameter(cr_param,'DESTYPE',text_parameter, 'PRINTER');
 RUN_PRODUCT(REPORTS,'e:\super\reports\sale_single1', ASYNCHRONOUS,RUNTIME,FILESYSTEM,CR_PARAM,NULL);
 
 --message('Old Bal after paramter list'||:global.my_var);
 destroy_parameter_list(cr_param);
 
 
select sale_seq.nextval into :cbk.temp_sale_seq from dual;
end if;

end;


rzkhan
Re: global variable [message #215100 is a reply to message #215014] Fri, 19 January 2007 05:32 Go to previous messageGo to next message
tanwanichandan
Messages: 8
Registered: January 2007
Location: Rajkot
Junior Member

hey ,
whatever u paased that is the user parameter . right !!!
so u can check ur paased variable in before/after report trigger

u can also change the value of that parameter at run time by using srw.set_field

so done naaaa right !!!!!!

enjoy
chandan



Re: global variable [message #215373 is a reply to message #215100] Sun, 21 January 2007 21:57 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Thanks. But my question still is there.. How can I pass a global variable from forms6i to Reports6i??

rzkhan
Re: global variable [message #219820 is a reply to message #215014] Fri, 16 February 2007 03:56 Go to previous message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
hi
are you not passing the global variable already in the following line

add_parameter(cr_param,'old_bal_pass',text_parameter, :global.my_var);
Previous Topic: creating lov based on parameter in first feild
Next Topic: FRM-41213, unable to connect to report server
Goto Forum:
  


Current Time: Mon Dec 05 06:57:52 CST 2016

Total time taken to generate the page: 0.24467 seconds