Home » Developer & Programmer » Forms » report from forms (Forms 6i)
report from forms [message #415130] Sat, 25 July 2009 02:11 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

how i can run a report based on values from form .By clicking on a push button.
Re: report from forms [message #415144 is a reply to message #415130] Sat, 25 July 2009 05:38 Go to previous messageGo to next message
ali_sakar
Messages: 22
Registered: February 2009
Location: Mumbai
Junior Member

1) create a parameter list in WBP trigger.
2) Use add_parameter and add parameters to above created parameter list
3) Use run_product to call the report and send this parameter list as an argument.
4) Create user parameters in the report to accept the sent parameters.

Ali.
Re: report from forms [message #415146 is a reply to message #415144] Sat, 25 July 2009 05:55 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks for your help , do you have a sample.
Re: report from forms [message #415147 is a reply to message #415146] Sat, 25 July 2009 06:16 Go to previous messageGo to next message
ali_sakar
Messages: 22
Registered: February 2009
Location: Mumbai
Junior Member

WHEN-BUTTON-PRESSED Trigger.
-----------------------------
declare
pl_id paramlist;
temp varchar2(30) := 'MY VALUE';
begin
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'TEMP_USER_PARA',text_PARAMETER,temp);
Run_Product(REPORTS,report_name,SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);
destroy_Parameter_List('tmpdata');
end;

In RDF
------
Under User Parameter Node, create a parameter by TEMP_USER_PARA name with datatype as char.

Ali
Re: report from forms [message #415151 is a reply to message #415147] Sat, 25 July 2009 07:27 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks ali i really appreciate your efforts.Please can you tell me why are you using that tempdata..
Re: report from forms [message #415265 is a reply to message #415151] Sun, 26 July 2009 23:50 Go to previous messageGo to next message
ali_sakar
Messages: 22
Registered: February 2009
Location: Mumbai
Junior Member

That is how you can send parameters to the Reports thru forms.
Read help about RUN_PRODUCT.
Re: report from forms [message #415492 is a reply to message #415130] Tue, 28 July 2009 01:45 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Did your Problem Solved ?


Regards


Shahzaib ismail
Previous Topic: Auto fill text field if LOV has 1 record.
Next Topic: Tree With select Node Populate
Goto Forum:
  


Current Time: Fri Dec 09 19:09:47 CST 2016

Total time taken to generate the page: 0.05950 seconds