Running a report through URL

Oct 10, 2012

In order to run a report directly in the URL, you will need to configure a file called cgicmd.dat in order to create a cmdkey.

  1. Go to “%DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration”.
  2. Open cgicmd.dat in a text editor.
  3. At the very end of the file add in the following:
    • RptSvrTest: userid=username/password@db_name destype=cache desformat=pdf %*
    • NOTE: You will need to change the username, password, and db_name to how you connect to your forms application. The word “RptSvrTest” is the name of the cmdkey we are creating. You may use a different name.
  4. Open up a web browser and type in the following:
    • http://hostname:9002/reports/rwservlet?cmdkey=RptSvrTest&config=env_name&report=name_of_report.
  5. If successful, a report should be generated.

NOTE: Make sure that the Reports environment has been configured.