| Parameter Form Issues.... [message #430030] |
Sat, 07 November 2009 01:31  |
sreejith.s
Messages: 11
Registered: November 2009 |
Junior Member |
|
|
Hi All,
I have two fields in the parameter form. One named 'employee number' and the other named 'document number'. Whenever the user enters an employee number, I want all the corresponding document numbers to be displayed in the form of an LOV. I'm not sure if its possible to do this in Oracle. In case I have to call the document numbers from the form, please guide me on how to go about the procedure.
Any help will be highly appreciated.
Regards,
Shri
|
|
|
| Re: Parameter Form Issues.... [message #430034 is a reply to message #430030] |
Sat, 07 November 2009 01:58  |
Littlefoot
Messages: 9228
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
As far as I can tell, not possible through Reports parameter form. (Though, only once I've seen someone saying that he had done that, but he had never replied and showed how to do it.) You could, on the other hand, write your own "parameter form" using Forms Developer which provides more flexibility (including the one you are talking about).
|
|
|
|
|
| Re: Parameter Form Issues.... [message #430429 is a reply to message #430073] |
Tue, 10 November 2009 06:44 |
|
You need to call ( in a program unit) all the parameters from form you are goin to design suppose you have a form with two feilds "Employee Numner" and "Document Number" .
on when-button-pressed
PROCEDURE PARAM_LIST IS
pl_id paramlist;
BEGIN
pl_id :=get_parameter_list('Your_Para_Name');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id :=create_parameter_list('Your_Para_Name');
if id_null(pl_id) then
message('Error creating parameter list '||'Your_Para_Name');
end if;
Add_Parameter(pl_id,'P_EMPNUMBER',TEXT_PARAMETER,:EMP_NUMBER);
Add_Parameter(pl_id,'P_DOCNUMBER',TEXT_PARAMETER,:DOC_NUMBER);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'no');
run_product(REPORTS,'Your_Report_Name', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, null);
END;
If you are actually copying only the above code  then make sure you have :EMP_NUMBER and :DOC_NUMBER on your form as well as P_EMPNUMBER and P_DOCNUMBER on your report added Otherwise take it as a refrence
Populate the document number record group on the basis of employee number .
Happy Reporting through Form parameter
Jak
|
|
|
] 
Members
Search
Help
Register
Login
Home
