Unable to run report from form button [message #634402] |
Mon, 09 March 2015 08:46 |
|
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
-
Attachment: forms.png
(Size: 62.44KB, Downloaded 1901 times)
|
|
|
Re: Unable to run report from form button [message #634407 is a reply to message #634402] |
Mon, 09 March 2015 13:24 |
joy_division
Messages: 4963 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}
|
|
|
|