| Pass a Enter Query from Form to Report [message #147667] |
Sat, 19 November 2005 00:02  |
ilhan
Messages: 3
Registered: November 2005
|
Junior Member |
|
|
Hi everybody
Pls can u tell me how i pass the enter query from form to report.
Which is not creating it in REPORT.
Pls who experts this answer you are heartest appreciated!!
This is for urgent!
Thanks in advance.
Regards
Ilhan
|
|
|
|
|
|
| Re: Pass a Enter Query from Form to Report [message #147678 is a reply to message #147667] |
Sat, 19 November 2005 01:11  |
ilhan
Messages: 3
Registered: November 2005
|
Junior Member |
|
|
Thanks for reply kiran,
How i don't know!
For (E.g)
1.Name of the Parameter in Forms: Comp_Statement.
2.I have a non basetable items in control block (E.g Code)
3.One Push button in control Block (E.g.Print).
4.My Target is When i press the Print Button Print the report as this query.
Select * from FND_COMPANY WHERE COMP_CODE IN(:control_blk.code).
5.I have created the user paremeter like same as Comp_Statement.
6.I don't want to write this query in REPORT.
7.Pls Check this statement.
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,'Comp_Statement',data_Parameter,'Select * from fnd_company where comp_code in(:Control_Blk.code)';
Add_parameter(pl_id,'comp_Statement',PARAMFORM,'NO');
RUN_PRODUCT(REPORTS,'D:\PROJCET\COMP.RDF',SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
END;
Pls check the line 9,10 in above code.
Pls Is it possible to pass this query from form to report without writing in report.
If possible how to write the code, where this query to it.
Thanks for spending a time
Once again thanks in advance for quick response.
Pls most urgent for me!
-Ilhan
Add_Parameter(PLComp_statement,
I want to call a report from Form using RUN_PRODUCT.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
