Home » Developer & Programmer » Reports & Discoverer » Re: How to pass values from Forms to Reports
Re: How to pass values from Forms to Reports [message #90405] Tue, 15 February 2005 08:17 Go to next message
Venkat Narasingu
Messages: 8
Registered: January 2003
Junior Member
Hi,
I created a M/D form and I am trying to pass the value which is SSN(in form) to form. But whenever I pressed the pushbutton I am able to run the Blank Report. Please help me how I can run the report so that when I clik the push button on form I need the report should open with data showing on report not Blank report.
Thank you
Venkat
Re: How to pass values from Forms to Reports [message #169353 is a reply to message #90405] Wed, 26 April 2006 06:59 Go to previous messageGo to next message
Numan
Messages: 14
Registered: November 2003
Junior Member
well create parameter list in your form and also create parameter in report u r calling.
pass parameter to run this report,in order to run report directly add following code.

add_parameter(pm_id,'PARAMFORM',TEXT_PARAMETER,'NO');

hope it works,

Numan
Re: How to pass values from Forms to Reports [message #211670 is a reply to message #90405] Sun, 31 December 2006 01:43 Go to previous messageGo to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

Hello Friend

I have understand ur problem .......
If u did't solve this problem before getting this mail.
Then give me reply ......
I will send u the code and example.........

Shakti
icon14.gif  Re: How to pass values from Forms to Reports [message #212077 is a reply to message #211670] Wed, 03 January 2007 12:50 Go to previous messageGo to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

hi shakti,
i have the same problem could u please send me the code, example.
thank u .
i m waiting.
regards.
Re: How to pass values from Forms to Reports [message #212183 is a reply to message #90405] Thu, 04 January 2007 03:55 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member

hi venkat ,

have u able to solve the problem use trigger when-button-pressed and I will end u the detail answer for that.

ashu
Re: How to pass values from Forms to Reports [message #216534 is a reply to message #212077] Mon, 29 January 2007 04:55 Go to previous messageGo to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member



sorry friend ,


I am sending u reply after a lot time..

Hope it will work for u.....

I m sending u the code.......






declare
pl_id paramlist;
--rep_id report_object;
-- v_report varchar2(100);
V_CHAR VARCHAR2(100);
begin

pl_id:= get_parameter_list('company_name');

if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;


pl_id := create_parameter_list('company_name');




Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'P_1', TEXT_PARAMETER, 'ACC');
/*
--Here P_1 is the user parameter in my report named employee
** Run the report synchronously, passing the parameter list
*/

Run_Product(REPORTS, 'c:\windows\desktop\employee.rdf', SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);


end;
Re: How to pass values from Forms to Reports [message #298783 is a reply to message #90405] Thu, 07 February 2008 12:06 Go to previous message
hamadh
Messages: 11
Registered: October 2007
Junior Member
thank you

[Updated on: Thu, 07 February 2008 13:23]

Report message to a moderator

Previous Topic: Problem with DESNAME
Next Topic: Character mode report printing
Goto Forum:
  


Current Time: Thu Dec 08 16:06:54 CST 2016

Total time taken to generate the page: 0.08207 seconds