Running Reports From FORMS 10g [message #460527] |
Fri, 11 June 2010 11:46 |
mrizwan_amin
Messages: 1 Registered: May 2010 Location: Pakistan
|
Junior Member |
|
|
Hi,
I have installed Oracle 10g DB and Developer Suite 10g and have made a simple report in it. This report runs perfectly fine when run from Reports Developer even in Browser. But when I called this report from FORM I get error.
The Trigger behind WHEN-BUTTON-PRESSED is
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
v_parameter_string varchar2(4000);
BEGIN
v_parameter_string := 'server=rep_fsprod';
v_parameter_string := v_parameter_string||'&report=C:\VENUS1\REPORTS\MODULE2.rdf';
v_parameter_string := v_parameter_string||'&userid=venus1/venus1@ora10g';
v_parameter_string := v_parameter_string||'&execution_mode=batch';
v_parameter_string := v_parameter_string||'&comm_mode=synchronous';
v_parameter_string := v_parameter_string||'&destype=cache';
v_parameter_string := v_parameter_string||'&desformat=pdf';
web.show_document('h t t p ://dbserver:8889/reports/rwservlet?'||v_parameter_string,'_blank');
END;
I also set my Report Server as rep_fsprod using CMD
rwserver server=rep_fsprod
I have made changes in .env files adding the REPORTS_PATH in it of the location where my reports are placed.
Also have made changes in REGISTRY adding in REPORTS_PATH the same location.
But when I press button the Browser window opened shows the error REP-51002 - Bind to Reports Server rep_fsprod failed
Please Help me urgent, as I need to run reports from FORMS including ones with Parameters.
Rizwan
|
|
|
|