Home » Developer & Programmer » Forms » how could I use MENU to call report (10g , Win XP)
how could I use MENU to call report [message #335424] Tue, 22 July 2008 02:56 Go to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi, all

I'm using the following procedure to call Reports within form
PROCEDURE rep_applic_data
IS
   repid        report_object;
   v_rep        VARCHAR2 (100);
   rep_status   VARCHAR2 (20);
BEGIN
   repid := FIND_REPORT_OBJECT ('REP_APPLIC_DATA');
   SET_REPORT_OBJECT_PROPERTY (repid, report_desformat, 'htmlcss');
   SET_REPORT_OBJECT_PROPERTY (repid, report_server, 'repserver10g');
   v_rep := RUN_REPORT_OBJECT (repid);
   rep_status := REPORT_OBJECT_STATUS (v_rep);

   WHILE rep_status IN ('RUNNING', 'OPENING_REPORT', 'ENQUEUED')
   LOOP
      rep_status := REPORT_OBJECT_STATUS (v_rep);
   END LOOP;

   IF rep_status = 'FINISHED'
   THEN
      web.show_document (   'http://localhost:8889/reports/rwservlet/'
                         || 'getjobid'
                         || SUBSTR (v_rep, INSTR (v_rep, '_', -1) + 1)
                         || '?'
                         || 'server=repserver10g',
                         '_blank'
                        );
   ELSE
      MESSAGE ('Error when running report');
   END IF;
END;

and define the report path within the NODE REPORT within the module ,

please, how could I use MENU to call the report
thanks
Re: how could I use MENU to call report [message #339217 is a reply to message #335424] Thu, 07 August 2008 01:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you tried writing code that calls this procedure from a menu?

David
Re: how could I use MENU to call report [message #339300 is a reply to message #339217] Thu, 07 August 2008 04:35 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
djmartin wrote on Thu, 07 August 2008 01:55
Have you tried writing code that calls this procedure from a menu?


hi, dear David

I try many times without any point of success (Perhaps I mis-understand the mechanism) ,

but, I tried using an empty CANVAS on separate Form with PRE-FORM triger calling the report procedure
then,
in menu ,just call this form , the report works properly.

until I get my point, this method works nice.

thanks

/forum/fa/4744/0/
  • Attachment: rep1.PNG
    (Size: 78.79KB, Downloaded 1063 times)
Re: how could I use MENU to call report [message #339370 is a reply to message #335424] Thu, 07 August 2008 06:48 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
If you working with 9i or 10g Database, maybe you could write a database procedure to invoke your report from the database and call this procedure from the menu.

search for event-driven publishing
Re: how could I use MENU to call report [message #339672 is a reply to message #339300] Fri, 08 August 2008 02:08 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Why not call the report from the Menu item's 'Menu Item Code'?

David
Re: how could I use MENU to call report [message #339842 is a reply to message #339672] Fri, 08 August 2008 18:36 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi,
thanks all for your concern

djmartin wrote on Fri, 08 August 2008 02:08
Why not call the report from the Menu item's 'Menu Item Code'?

how to specify the report's file path?
thanks
Re: how could I use MENU to call report [message #341210 is a reply to message #339842] Sun, 17 August 2008 21:04 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you got a report to work from a form yet?

David
Previous Topic: Is there a length on global variables
Next Topic: Run any report
Goto Forum:
  


Current Time: Mon Feb 10 00:13:14 CST 2025