3 Replies Latest reply: Jan 24, 2013 10:16 AM by AlexDiniasi RSS

    SRW.RUN_REPORT working with oracle 10g and oracle IAS 10G or not?

    533096
      Hello,

      Is the SRW.RUN_REPORT working with oracle 10g and oracle IAS 10G or not?

      or we must use others thing like SRW.SET_HPERLINK?

      thank's
        • 1. Re: SRW.RUN_REPORT working with oracle 10g and oracle IAS 10G or not?
          AlexDiniasi
          Hello

          If you are migrating from 6i check the following metalink note:
          How to Migrate a Button with Srw.run_report Command from Client/Server into Web (Doc ID 130780.1)

          Other useful resources:
          Using SRW Packaged Procedures In Reports (Doc ID 61643.1)
          How to Create Drill Down Web Reports Using Hyperlinks (Doc ID 160262.1)

          Kind regards,
          Alex

          If someone's answer is helpful or correct please mark it accordingly.
          • 2. Re: SRW.RUN_REPORT working with oracle 10g and oracle IAS 10G or not?
            533096
            Hello,

            thnak you for you're answer.

            I don't have metalink access.

            can you please send me the note.
            • 3. Re: SRW.RUN_REPORT working with oracle 10g and oracle IAS 10G or not?
              AlexDiniasi
              Hello,

              Purpose
              A client/server application may have a button within a Report 
              that runs another Report with srw.run_report command. This 
              article describes how to implement this behavior, that works in 
              a client/server reports application, into Web using 
              DESFORMAT=html or DESFORMAT=pdf.
              Scope and Application
              This article is intended for any user, who wants to migrate a 
              reports client/server application, that calls a second report
              via button, into Web.
              How to Migrate a Button with Srw.run_report Command from Client/Server into Web

              CHARACTERISTICS in CLIENT/SERVER ENVIRONMENT
              --------------------------------------------

              The PL/SQL trigger property concerning a button is a PL/SQL
              procedure that is executed when the button is selected in the
              live previewer view.
              The trigger can be used to dynamically call another report
              (drill down) or execute any other PL/SQL.
              It only works when running the report from runtime with
              DESTYPE=preview, it does not work when running the report,
              which includes a button with srw.run_report command, from report
              builder.

              Assume the following application:

              - In layout model you have created e. g. a red button (with tools
              palette --> button). When the user will press the red button in
              runtime, another report: emp.rdf should be opened.

              - This has been implemented by an PL/SQL trigger (see properties
              --> button behavior):


              srw.run_report('report=c:\temp\emp.rdf desformat=pdf');




              CHARACTERISTICS IN WEB ENVIRONMENT
              ----------------------------------

              From Reports Online-help you can read the following button
              restriction:
              "Buttons do not appear in printed output". So when e. g. printing
              the report into a file, buttons cannot be used for intended
              behavior.

              When - on the other hand - running the same application as
              described above in Web with DESFORMAT=html or DESFORMAT=pdf,
              the following behavior occur: Button is shown in browser or
              Acrobat Reader with title and when pressing the button -->
              nothing happens.

              Check this out: If DESFORMAT=html, select from Netscape Navigator
              menu --> view --> page source. Something like the following can be
              seen when implemented a button:

              <td colspan=9 rowspan=10><table border=2 cellspacing=0 cellpadding=0> <tr><td width=271 align=center valign=middle><font face="Courier New"> <tt>Press to run emp.rdf </tt></font> </table> <td>


              No action is implemented.


              SOLUTION FOR PDF OUTPUT IN WEB:
              ------------------------------

              How to run a Web report concerning a button for opening another
              report in pdf:

              - Within layout model create a rectangle and fill it with the
              color you want to, e. g. red.

              - Create a text field directly onto this rectangle with title,
              e. g. 'Press for runnning the report emp.rdf'.

              Be aware, that the size of the text field will be the same as
              the red rectangle and have the same position.

              - Create a format trigger e. g. for the text field and insert the
              following code:

              function B_2FormatTrigger return boolean is begin SRW.SET_PDF_ACTION('rwrun60 userid=scott/tiger@odin report= c:\temp\datum.rdf'); return (TRUE); end;



              Run the original Report on the Web with DESFORMAT=pdf.
              Press the button/rectangle and see, that the report emp.rdf
              will be opened now.



              SOLUTION FOR HTML OUTPUT IN WEB:
              -------------------------------

              How to run a Web report concerning a button for opening another
              report in html:

              - Within layout model create a rectangle and fill it with the color
              you want to, e. g. green.

              - Create a text onto this rectangle with title, e. g.
              'Press for runnning the report emp.rdf'.


              Be aware, that the size of the text field will be the same as the
              green rectangle and have the same position.

              - Create a format trigger and insert the following code:

              function B_4FormatTrigger return boolean is begin srw.set_hyperlink_attrs('target="_parent"'); srw.set_hyperlink('http://host.com:80/dev60cgi/rwcgi60.exe? server=Repserv&report=c:\temp\emp.rdf&userid=scott/tiger@ testdb&destype=cache&desformat=HTML'); return (TRUE); end;



              Run the original Report on the Web with DESFORMAT=html. Press the
              button/rectangle and see, that the report emp.rdf will be opened
              within browser now.


              Kind regards,
              Alex

              If someone's answer is helpful or correct please mark it accordingly.