Home » Developer & Programmer » Forms » Unable to run report from form button
Unable to run report from form button [message #634402] Mon, 09 March 2015 08:46 Go to next message
mikrimouse1
Messages: 4
Registered: March 2015
Junior Member
I have this simple form with few textboxes and button for insert and button for inserted entries. In the picture is pl code for call template it should call report when I run form but it doesn.

So pls if someone know what could be problem here to write it.

DECLARE
report_id Report_Object;
ReportServerJob VARCHAR2(254);
BEGIN
report_id := find_report_object('REPORT18');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'izvjestaj_rep');
ReportServerJob := run_report_object(report_id);
END;

REPORT18 is the name of report i include in object navigator, izvjestaj_rep is the name of the report services
/forum/fa/12527/0/
  • Attachment: forms.png
    (Size: 62.44KB, Downloaded 376 times)
Re: Unable to run report from form button [message #634407 is a reply to message #634402] Mon, 09 March 2015 13:24 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
I would look at the report server status, which is a URL that the person who installed the app server should be able to give you.

It's something like:
http://{app server:port}/reports/rwservlet/showjobs?queuetype=past&server={report server name}
Re: Unable to run report from form button [message #634595 is a reply to message #634407] Wed, 11 March 2015 13:09 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Does your report run on a Windows or UNIX/Linux server? If UNIX/Linux, they are case sensitive. Is your report file in UPPER, LOWER or Mixed Case?

Craig...
Previous Topic: what equivalent to run_product in forms11g
Next Topic: Execution after process
Goto Forum:
  


Current Time: Mon Aug 03 16:23:13 CDT 2020