Home » Developer & Programmer » Reports & Discoverer » pass parameter to report from form (form builder 6i & report builder 6i)
pass parameter to report from form [message #418892] Wed, 19 August 2009 01:41 Go to next message
Messages: 61
Registered: April 2008
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';
 link := '';
end if;

report sql(report buider)
select a.val1,b.valb
from abc a,bde||:P_LINK b     --> can do this?
where a.id = b.id;

Re: pass parameter to report from form [message #418956 is a reply to message #418892] Wed, 19 August 2009 05:35 Go to previous messageGo to next message
Messages: 12825
Registered: September 2008
Location: Rainy Manchester
Senior Member
read up on lexical parameters in report builder help.
Re: pass parameter to report from form [message #419359 is a reply to message #418892] Fri, 21 August 2009 08:53 Go to previous message
Messages: 11
Registered: August 2009
Location: US
Junior Member

I'm using RAQ Report. It can pass parameter to report easily. It's a free excel-like reporting tool. Maybe you can use it.
Previous Topic: Data Display Problem.. (merged 5) 9i - windows
Next Topic: How to configure reports in linux to use particular fonts
Goto Forum:

Current Time: Tue Aug 22 19:52:20 CDT 2017

Total time taken to generate the page: 0.02446 seconds