Hi All,
I have a report which the parameter developed from form builder.
In my form, i checked the location code.if location code is A then it will pass a parameter.but this parameter is not for script condition but for table connection
e.g :
parameter form (form builder) key-print trigger
if location = 'A' then
link := '@aa.bb.com';
else
link := '';
end if;
Add_Parameter(pl_id,'P_LINK',TEXT_PARAMETER,link);
report sql(report buider)
select a.val1,b.valb
from abc a,bde||:P_LINK b --> can do this?
where a.id = b.id;
] 
Blog
Search
Help
Members
Register
Login
Home
