|
|
|
|
| Re: Problem in sending a parameter to report from form [message #119196 is a reply to message #118795] |
Wed, 11 May 2005 02:38   |
subba lakshmi
Messages: 36
Registered: March 2005
|
Member |
|
|
hello aditya,
i was allocated a system temporarily which doesn't have reports,
but i tried the same with two forms.it is working fine.try the same with reports
form1
with text box and button
on when-button-pressed
declare
pl paramlist;
begin
if id_null(pl) then
pl:=create_parameter_list('simple');
add_parameter(pl,'param',text_parameter,:block3.text_item4);
call_form('d:\jslakshmi\frm2.fmx',no_hide,no_replace,query_only,pl);
end if;
end;
form2
with a textbox and a parameter named param.
in when-new-form-instance
declare
pl paramlist;
begin
pl:=get_parameter_list('simple');
:block3.text_item4:=:parameter.param;
end;
instead of when-new-form-instance you use corresponding report triggers.
from
subba lakshmi
|
|
|
|
|
|
| Re: Problem in sending a parameter to report from form [message #119339 is a reply to message #118676] |
Thu, 12 May 2005 00:18 |
Gokul
Messages: 21
Registered: October 2000
|
Junior Member |
|
|
Solution :
1)
add_parameter_list(pl_id,'P_remark',text_parameter,:Block.Item);
Use the following instead of the above :
add_parameter_list(pl_id,'P_remark',text_parameter,''''||:Block.Item||'''');
Reason :
If You pass a string(more than one words or with space), you must enclose the string within single quotes.
2)
This will also work
set_report_object_property(report_object_id,report_other,'P_remark='''||:Block.Item||'''');
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
