Run Report From Form [message #478513] |
Sun, 10 October 2010 02:58 |
beginner88
Messages: 45 Registered: June 2010
|
Member |
|
|
Hello
Following is basic program that i create :
When User Press Execute Query Button at Run time ,then Program shows him Detail Of employess from Employess Table In Form Style .
For example If Present Record is Of Employee Number 7369 ,Then user can Have also the option or button that by which he can also view Report Of Employee Number 7369 .
I am unable to understand that i need to write a code [Report Buitins] for it or i need to do something from REPORTS option avalabe in Froms .
Regards .
[Updated on: Sun, 10 October 2010 02:59] Report message to a moderator
|
|
|
Re: Run Report From Form [message #478516 is a reply to message #478513] |
Sun, 10 October 2010 03:29 |
ranamirfan
Messages: 535 Registered: January 2006 Location: Pakistan / Saudi Arabia
|
Senior Member |
|
|
Dear,
Read About Add_parameter From Forms help & then Try it.
DECLARE
pl_id ParamList;
pl_name VARCHAR2(50) := 'tempdata';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List(pl_name);
Add_Parameter(pl_id, 'EmpCode', TEXT_PARAMETER, :EmployeeBlock.EmpCode);
Add_Parameter(pl_id, 'Destype', TEXT_PARAMETER, 'Preview');
Run_Product(REPORTS, 'D:\Reports\Employee.Rep', SYNCHRONOUS, RUNTIME,FILESYSTEM,Pl_id,NULL);
END;
Hope this'll help you.
Regards,
Irfan
|
|
|
|
|