Home » Developer & Programmer » Reports & Discoverer » Report only run on Server
Report only run on Server [message #242410] Fri, 01 June 2007 17:08 Go to next message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
Hi,

Problem with reports i guess...

I've been searching on the forums and google but i can't find a solution for this.

I have one form and one report.

On my form i have a button with the next pl/sql code:

PROCEDURE RUN_REPORT IS

  p_rpt_param_list  paramlist;

  report_id       REPORT_OBJECT;
  ReportServerJob VARCHAR2(100);
  v_jobID         VARCHAR2(100);
  rep_status      VARCHAR2(20);
  reportserver    VARCHAR2(30);
  v_url           VARCHAR2(200);
  v_url2          VARCHAR2(200);

  usr_sessionid   NUMBER;
 
  report_not_generated EXCEPTION;

  BEGIN
  	
  SELECT USERENV('sessionid') into usr_sessionid FROM DUAL;

  IF NOT Id_Null(p_rpt_param_list) then
      Destroy_Parameter_List(p_rpt_param_list);
  END IF;
  
  p_rpt_param_list := Create_Parameter_List ('tmp');

  IF (get_application_property(user_interface)='WEB') THEN

   reportserver := 'rep_JETCOSW05_FRHOME';
   report_id := find_report_object('LISEST');
   
   SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_COMM_MODE, SYNCHRONOUS);
   SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_EXECUTION_MODE, BATCH);
   SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESTYPE, FILE);
   SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESFORMAT, 'pdf');
   SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_SERVER, reportserver);

   Add_Parameter(p_rpt_param_list,'paramform',TEXT_PARAMETER,'no');   
   Add_Parameter(p_rpt_param_list,'PRINTJOB',TEXT_PARAMETER,'NO');

    ReportServerJob := run_report_object(report_id, p_rpt_param_list);
   v_jobID := substr(ReportServerJob,length(reportserver)+2,length(ReportServerJob));

   IF ReportServerJob is NOT NULL THEN
       rep_status := report_object_status(ReportServerJob);

       WHILE rep_status in ('RUNNING', 'OPENING_REPORT','ENQUEUED') LOOP
         rep_status := report_object_status(ReportServerJob);
       END LOOP;
       IF rep_status != 'FINISHED' THEN
          raise report_not_generated;
       END IF;
       
  v_url := '/reports/rwservlet/getjobid'||v_jobID||'?server='||reportserver;
  v_url2 := 'javascript:window.open("'||v_url ||'", "", "fullscreen=no, 
             titlebar=no, location=no, toolbar=no, menubar=no, status=no, resizable=yes");
             self.close()';
             
      Web.Show_Document(v_url2,'_blank');
   ELSE
       raise report_not_generated;
   END IF;

  END IF;

  Destroy_Parameter_List(p_rpt_param_list);

  
END;


I config formwebs.config and the default.env.

formwebs.config:

[aplicacion]
envFile=aplica.env
lookAndFeel=Oracle
colorScheme=teal
pageTitle=HOLA MUNDO
form=LISEST

On default.env i only chance the forms path.

The problem is that on the server i can run the form and also the report, but on client i can only run the form, the report doesn't run.

Anyone knows why?

Thanks in advance
Re: Report only run on Server [message #242412 is a reply to message #242410] Fri, 01 June 2007 17:19 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does it mean, "the report doesn't run"? Is there an error? If so, which one?
Re: Report only run on Server [message #242415 is a reply to message #242410] Fri, 01 June 2007 18:21 Go to previous messageGo to next message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
Hi littlefoot

Sorry, i get no error, i just press the button then looks like its doing something (the progress bar moves) and after 15 seconds the progress bar stops and nothing happen, i just wait like half an our and nothing.

What would it be?
Thanks again

[Updated on: Fri, 01 June 2007 18:24]

Report message to a moderator

Re: Report only run on Server [message #242469 is a reply to message #242415] Sat, 02 June 2007 08:13 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there a pop-up blocker enabled which would prevent report to show on the screen?
Re: Report only run on Server [message #242950 is a reply to message #242410] Tue, 05 June 2007 10:27 Go to previous messageGo to next message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
Good point, but i deactivated the pop-up blocker and still with the same problem,

Could it be something with the security of the browser?

By the way im using Internet Explorer ver 6.0


Thanks again
Re: Report only run on Server [message #243044 is a reply to message #242950] Tue, 05 June 2007 15:52 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See whether the following Internet Explorer option check box is checked or not (should be): Tools - Internet Options - Advanced tab - Security section - Allow active content to run in files on My Computer
Re: Report only run on Server [message #243057 is a reply to message #242410] Tue, 05 June 2007 17:49 Go to previous messageGo to next message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
Yes, the Allow active content to run in files on My Computer is checked.

I found that on one machine i can run the report, so i discard a bad configuration on the server and a lack of configuration/software on client side.


I only have installed jinitiator 1.3.1.22, do i need something else?

Thanks

[Updated on: Tue, 05 June 2007 17:50]

Report message to a moderator

Re: Report only run on Server [message #243117 is a reply to message #243057] Wed, 06 June 2007 02:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I use the same JInit ...

I'm sorry, but there's nothing else I could suggest you to do at the moment.
Re: Report only run on Server [message #243197 is a reply to message #243117] Wed, 06 June 2007 07:54 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Log a service request on Metalink?
Re: Report only run on Server [message #243566 is a reply to message #242410] Thu, 07 June 2007 14:43 Go to previous messageGo to next message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
I've been searching the reason why i can open the report on one machine and on another can't

The one that opens the report has windows xp service pack 1 and the internet explorer is 6.0.2800 for sp1, the other has windows xp service pack 2 and ie 6.0.2900 for sp2.

I tried to open the report from a machine with windows 98SE and with internet explorer 6.0.2800 and it opened, so i think the problem is not a bad configuration, but the ie version.

Maybe there are some problems running reports on that 6.0.2900 version of ie or the firewall of the sp2 is blocking the report?

Littlefoot could you give me your ie version in order to compare.

Thanks...

[Updated on: Thu, 07 June 2007 16:38]

Report message to a moderator

Re: Report only run on Server [message #243886 is a reply to message #243566] Sun, 10 June 2007 17:09 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is 6.0.2900.2180 running on XP with SP2.
Re: Report only run on Server [message #244108 is a reply to message #242410] Mon, 11 June 2007 10:52 Go to previous message
kornflakes
Messages: 14
Registered: May 2007
Junior Member
Ok, I found it. Cool

Changing this:

v_url := '/reports/rwservlet/getjobid'||v_jobID||'?server='||reportserver;

v_url2 := 'javascript:window.open("'||v_url ||'", "", "fullscreen=no,titlebar=no, location=no, toolbar=no,menubar=no, status=no, resizable=yes");
             self.close()';
             
      Web.Show_Document(v_url2,'_blank');


With this:

     Web.Show_Document('http://192.200.1.5:7779/reports/rwservlet/getjobid' || v_jobID ||'?server' || reportserver ,'_blank');


And now i can open the form and also the report, without problem and on any ie version.

That javascript thing doesn't want me.

Thanks for everything
Saludos desde Mexico.

[Updated on: Mon, 11 June 2007 10:55]

Report message to a moderator

Previous Topic: report headers
Next Topic: Report Output in Apps
Goto Forum:
  


Current Time: Fri Dec 09 09:28:41 CST 2016

Total time taken to generate the page: 0.07360 seconds