OraFAQ Forum: Forms » report from forms

Home » Developer & Programmer » Forms » report from forms (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

report from forms [message #415130]

Sat, 25 July 2009 02:11

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.

Report message to a moderator

Re: report from forms [message #415144 is a reply to message #415130]

Sat, 25 July 2009 05:38

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.

Report message to a moderator

Re: report from forms [message #415146 is a reply to message #415144]

Sat, 25 July 2009 05:55

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Thanks for your help , do you have a sample.

Report message to a moderator

Re: report from forms [message #415147 is a reply to message #415146]

Sat, 25 July 2009 06:16

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

Report message to a moderator

Re: report from forms [message #415151 is a reply to message #415147]

Sat, 25 July 2009 07:27

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..

Report message to a moderator

Re: report from forms [message #415265 is a reply to message #415151]

Sun, 26 July 2009 23:50

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.

Report message to a moderator

Re: report from forms [message #415492 is a reply to message #415130]

Tue, 28 July 2009 01:45

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Did your Problem Solved ?

Regards

Shahzaib ismail

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:48:53 CDT 2024