| How can i passed input in forms to reports as parameter [message #80497] |
Wed, 02 October 2002 18:07  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
hi to all!
Can anyone give me an idea how can i used my input in forms and passes it to reports. I call a report in forms thru run products built in and i wanted if possible, passed my input to reports as my parameter.
Is this possible?
Your help is highly appreciated..
Thanks
|
|
|
|
| Re: How can i passed input in forms to reports as parameter [message #80533 is a reply to message #80497] |
Wed, 09 October 2002 02:13  |
Shiju Joy
Messages: 4
Registered: February 2002
|
Junior Member |
|
|
Hi,
Firstly u need to create a Parameter List.
p := Create_Parameter_List('P');
Then add parameters to it.
Add_Parameter(p,'TESTPARAM',TEXT_PARAMETER,'HELLO');
Then run report with the parameter.
RUN_PRODUCT(REPORTS,'MYREPORT',SYNCHRONOUS,RUNTIME,FILESYSTEM,p);
Plz note the Report (rdf file) should have a User Paramater with the same parameter name which is used while adding parameter.
In this case the user parameter is TESTPARAM
For example ---
DECLARE
al_button Number;
p ParamList;
BEGIN
p := Get_Parameter_List('P');
IF Id_Null(p) THEN
p := Create_Parameter_List('P');
END IF;
Add_Parameter(p,'TESTPARAM',TEXT_PARAMETER,'HELLO');
RUN_PRODUCT (REPORTS,'MYREPORT',SYNCHRONOUS,RUNTIME,FILESYSTEM,p);
END;
Shiju
shijujoy@hotmail.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
