Home » Developer & Programmer » Forms » Call report from Form. (Oracle Form 10g.)
Call report from Form. [message #530835] Fri, 11 November 2011 00:21 Go to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

I used Report Builder 9.0.4.0.33, and i want to call 1 report name is "DOCK_RECEIPT.rdf" from Form when click into button name is "Print". I write code in When-button-press follow:
This is code call report from Form.
Declare
   pl_id paramlist;
Begin
   pl_id := get_parameter_list('tmpdata');
   If Not id_null(pl_id) Then
      destroy_parameter_list(pl_id);
   End If;
   pl_id := create_parameter_list('tmpdata');
   add_parameter(pl_id, 'PC_SLIP_NO', text_parameter, :pallet.slip_no);
   add_parameter(pl_id, 'PC_CONTAINER', text_parameter, :control.nyk_container_no);
   add_parameter(pl_id, 'PC_RETURN', text_parameter, :control.txt_reason);
   add_parameter(pl_id, 'PC_WH', text_parameter, :control.from_loc);
   add_parameter(pl_id, 'PC_SEAL_NO', text_parameter, :control.nyk_seal_no);
   add_parameter(pl_id, 'PC_CAR_NO', text_parameter, :control.car_no);
   run_product(reports, 'DOCK_RECEIPT.rdf', synchronous, runtime, filesystem, pl_id, Null);
   If Not id_null(pl_id) Then
      destroy_parameter_list(pl_id);
   End If;
End;


On report "DOCK_RECEIPT" has parameter same parameter on Form. But when i click button "Print" then can't call report,while form and report that together folder.
Now, i want to question, how must configure report builder for call report from form that?
example: about directories,path, etc
Re: Call report from Form. [message #531053 is a reply to message #530835] Sat, 12 November 2011 08:03 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:

Run_Product(reports, 'DOCK_RECEIPT.rdf', synchronous, runtime, filesystem, pl_id, Null);


Try it with full Report path like D:\Dock_Receipt.rdf .

Please also read this post.

http://www.orafaq.com/forum/mv/msg/175685/528203/81953/#msg_528203


Hope it'll help you.

Regards,
Irfan
Re: Call report from Form. [message #531132 is a reply to message #531053] Sun, 13 November 2011 20:50 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

i already do follow you but not call report from form.
Now, how do i do?
Re: Call report from Form. [message #531135 is a reply to message #531132] Mon, 14 November 2011 00:02 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

First Run your's report with out parameter using Report Built-in Run_Product() & then go ahead.
Re: Call report from Form. [message #531158 is a reply to message #531135] Mon, 14 November 2011 03:11 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

I still no call report from form, and i deploy to server but i don't know configure report server.
Now, i must how to do?
Please help detail for me.
Re: Call report from Form. [message #608834 is a reply to message #530835] Tue, 25 February 2014 06:10 Go to previous message
rakesh7800
Messages: 1
Registered: February 2014
Location: DELHI
Junior Member
THNKU SO MCH IRFAN BLESS YOU
Previous Topic: missing file c:\layout\awc\mystyle.css
Next Topic: updation is not happening when do insrt and update in same procedure in oracle forms
Goto Forum:
  


Current Time: Fri May 17 00:27:35 CDT 2024