oracle-databaseoraclereports

Calling report with oracle report builder 12


I need to call an other report with parameters from my report by report builder 12. But it seems to be, there is no button for calling an other one. Is there any way to call second report from the first one?


Solution

    1. First stop the report server. (OC4J instance also for 10g)
    2. Search for CGICMD.DAT file in Developersuite home. (for 10g It’s located at folder. And for 11g D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration)
    3. Open the CGICMD.DAT file and go to bottom line and add the bellow lines and modify as your value.

      ; hrs: userid=test/password@orcl server=rep_server desformat=pdf destype=cache paramform=no %* (Where first userid, report server name, report destination format, destination type and no parameter form.)

    4. Save and close the file.
    5. Now open the report which will have the link.
    6. Select the data field and press F11 to go code editor and add the bellow code before return (true); SRW.SET_HYPERLINK('http://SERVER_NAME:8889/reports/rwservlet?hrs+report='D:\ID_CARD_ALL.rep+EMPID='||:EMP_ID); (Change the report server url as you have, report name and parameter if you have)

    Compile and save the reports.

    Now Run the report server and run your report…

    LOVE U SETAREH