Parameter Form Issues.... [message #430030] |
Sat, 07 November 2009 01:31 |
sreejith.s
Messages: 26 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 #430073 is a reply to message #430034] |
Sun, 08 November 2009 00:03 |
sreejith.s
Messages: 26 Registered: November 2009
|
Junior Member |
|
|
Hi,
I have a push button on my form from where the report is invoked. Any help on where I should be making the changes in order to to get the fields as mentioned above?
Thanx for your earlier response.
Regards
Shri
|
|
|
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
|
|
|