Home » Developer & Programmer » Reports & Discoverer » Running Reports From FORMS 10g (Windows XP)
Running Reports From FORMS 10g [message #460527] Fri, 11 June 2010 11:46 Go to next message
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
Re: Running Reports From FORMS 10g [message #460911 is a reply to message #460527] Tue, 15 June 2010 08:24 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,


Check that your Reports Server is running and Reports Server name is correct."

"REP-51002: فشل الربط بخادم Reports Server wls_reports."


regards,


Irfan
Previous Topic: how create report xls
Next Topic: Report server problem : very urgent
Goto Forum:
  


Current Time: Fri May 29 03:05:46 CDT 2020