Problem in calling REPORTS from Forms [message #116128] |
Mon, 18 April 2005 00:12 |
dal_hit
Messages: 16 Registered: March 2005 Location: New York
|
Junior Member |
|
|
Hi Friends
I have a problem in calling REPORT from Form builder.
for that purpose i have attached a file with this mail.
i hope that you just go thought it & tell me solution .
|
|
|
|
|
|
Re: Problem in calling REPORTS from Forms [message #116206 is a reply to message #116129] |
Mon, 18 April 2005 10:13 |
Steve Corey
Messages: 336 Registered: February 2005 Location: RI
|
Senior Member |
|
|
Actually, the exact syntax is something like this:
RUN_PRODUCT(reports, 'server_file_path_to_report_location', SYNCHRONOUS|ASYNCHRONOUS, RUNTIME, FILESYSTEM, param_list_variable)
reports - specifies Oracle Reports as the prog you are calling
'server_file_path...' - specified location of the report (.RDF) on the application server (or your client if you are in C/S)
SYNCHRONOUS|AYSNCHRONOUS - modal/non-modal (see Forms help)
RUNTIME - default
FILESYSTEM - default
param_list_variable - the variable that holds your parameter list created in the declare section of your program unit:
Here is an example:
-- Module : Generate Report Button - Parameter Passing - Integrating Forms & Reports
-- Written by : Stephen Corey
-- Written on : October 10, 2004
declare
v_pl paramlist;
begin
v_pl := create_parameter_list('paramlist');
-- Add the parameters to the list
ADD_PARAMETER(v_pl, 'P_FILTER_BY', TEXT_PARAMETER, :PARAMETER.P_FILTER_BY);
ADD_PARAMETER(v_pl, 'P_USE_QUERY', TEXT_PARAMETER, :PARAMETER.P_USE_QUERY);
ADD_PARAMETER(v_pl, 'P_GROUP_BY', TEXT_PARAMETER, :PARAMETER.P_GROUP_BY);
ADD_PARAMETER(v_pl, 'p_ORDER_BY', TEXT_PARAMETER, :PARAMETER.P_ORDER_BY);
-- Suppress the Reports default parameter form to avoid double-entry nuisance
ADD_PARAMETER(v_pl, 'PARAMFORM', TEXT_PARAMETER, 'NO');
-- Make the call to Reports and pass the values to specificied report path
RUN_PRODUCT(reports, 'c:\DOCUMENTS AND SETTINGS\scorey\My Documents\Oracle Reports\HR Reports\Flexible_Termast_Base.rdf', ASYNCHRONOUS, RUNTIME, FILESYSTEM, v_pl);
--RUN_PRODUCT(reports, 'm:\oraclefhwa\fhwaappl\ridot\reports\US\scorey\TERMAST_FLEXIBLE_BASE.rdf', SYNCHRONOUS, RUNTIME, FILESYSTEM, v_pl);
-- Destroy the existing parameter list to remove it from memory
destroy_parameter_list(v_pl);
END;
If you need more help, please visit Metalink at http://metalink.oracle.com and search for document ID 1010797.6
HTH,
Steve
PS - Dal, please do not cross-post (eg in Forms forum and Reports forum) even though it is a question for both developer tools. A little patience goes a long way here (as I found out the hard way myself).
Take care.
[Updated on: Mon, 18 April 2005 10:16] Report message to a moderator
|
|
|
|