{"id":3203,"date":"2012-10-10T11:32:53","date_gmt":"2012-10-10T15:32:53","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/10\/10\/running-a-report-through-url\/"},"modified":"2017-05-16T08:20:45","modified_gmt":"2017-05-16T12:20:45","slug":"running-a-report-through-url","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/10\/10\/running-a-report-through-url\/","title":{"rendered":"Running a report through URL"},"content":{"rendered":"<p>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.<\/p>\n<ol>\n<li>Go to &#8220;%DOMAIN_HOME%\\config\\fmwconfig\\servers\\WLS_REPORTS\\applications\\reports_11.1.2\\configuration&#8221;.<\/li>\n<li>Open cgicmd.dat in a text editor.<\/li>\n<li>At the very end of the file add in the following:\n<ul>\n<li>RptSvrTest: userid=username\/password@db_name destype=cache desformat=pdf %*<\/li>\n<li>NOTE: You will need to change the username, password, and db_name to how you connect to your forms application. The word &#8220;RptSvrTest&#8221; is the name of the cmdkey we are creating. You may use a different name.<\/li>\n<\/ul>\n<\/li>\n<li>Open up a web browser and type in the following:\n<ul>\n<li>http:\/\/hostname:9002\/reports\/rwservlet?cmdkey=RptSvrTest&amp;config=env_name&amp;report=name_of_report.<\/li>\n<\/ul>\n<\/li>\n<li>If successful, a report should be generated.<\/li>\n<\/ol>\n<p>NOTE: Make sure that the Reports environment has been configured.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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. Go to &#8220;%DOMAIN_HOME%\\config\\fmwconfig\\servers\\WLS_REPORTS\\applications\\reports_11.1.2\\configuration&#8221;. Open cgicmd.dat in a text editor. 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[4,36],"tags":[11,16,13,37],"class_list":["post-3203","post","type-post","status-publish","format-standard","hentry","category-install-config","category-reports","tag-11g","tag-11gr2","tag-installation-setup","tag-reports"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=3203"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3203\/revisions"}],"predecessor-version":[{"id":9007,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3203\/revisions\/9007"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=3203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=3203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=3203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}