| Re: How to pass values from Forms to Reports [message #90405] |
Tue, 15 February 2005 08:17  |
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  |
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 #216534 is a reply to message #212077] |
Mon, 29 January 2007 04:55 |
|
|
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
