<\/p>\n
Usually a report is generated by clicking the "Run Report" button. For most customers, most of the time, this method works well. But there are times when you may need to skip the prompt page and proceed directly to the results page. As you may know, you can do this by adding Options for Ad Hoc Reporting:<\/strong><\/p>\n \u00b7 Display or Hide Detail Row In this example, we'll treat it as if you were going to execute a report directly into .PDF form, hiding the detail row, displaying sub-total and grand total rows, and passing a value of "100" as the first record selection.<\/p>\n The link to execute the report by passing the parameters will then look something like this:<\/strong><\/p>\n where<\/p>\n IPAddress<\/strong> — IP address of the server or qualified server name (ex: 192.168.1.100) Output Format List:<\/p>\n outfmt=0<\/strong> — HTML <\/p>\n","protected":false},"excerpt":{"rendered":" Executing a Report directly from a link and\/or URL Usually a report is generated by clicking the "Run Report" button. For most customers, most of the time, this method works well. But there are times when you may need to skip the prompt page and proceed directly to the results page. As you may know, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":557,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-734","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=734"}],"version-history":[{"count":12,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/734\/revisions"}],"predecessor-version":[{"id":8264,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/734\/revisions\/8264"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/557"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}?run=2<\/code> to the URL line. This will cause the page to run with the defaults from the prompt page. However, you may wish to override these defaults for Ad Hoc Reporting.<\/p>\n
\n\u00b7 Display or Hide Sub-total Row(s)
\n\u00b7 Display or Hide Grand total Row
\n\u00b7 Choose an Output Format
\n\u00b7 Pass Record Selection to Report
\n\u00b7 Specify Top 10 Style Parameters. Click here<\/a> to learn more about Top 10 Style Reports.<\/p>\nhttps:\/\/IPAddress\/mrcjava\/servlet\/DD.RXXXXXs?run=1&R001=100&D_DETAIL=0&S_CUSNO=1&G_TOTAL=1&outfmt=11<\/code><\/p>\n
\nDD<\/strong> — Data Dictionary in which report resides
\nRXXXXXs<\/strong> — Executable report program number
\n?<\/strong> — This is the indicator that there are parameters being passed to the RXXXXXs program
\nrun=1<\/strong> — Indicates to the program to bypass the prompt page and default settings, and to instead use the parameters which follow
\n&<\/strong> — This is a deliminator between parameters being passed
\nD_DETAIL=1<\/strong> — Specifies to include detail level in the report
\nS_CUSNO=1<\/strong> — Specifies to include the subtotal by the field CUSNO (customer number) that the report is sequenced by
\nG_TOTAL=1<\/strong> — Specifies to include grand total in the report
\noutfmt=11<\/strong> — Specifies the output format in which the report will be generated, PDF in this case
\nrptPage=FILE<\/strong> — This option allows you to control Pagename attributes. Learn more about Pagename here<\/a>.<\/p>\n
\noutfmt=1<\/strong> — Print Optimized HTML
\noutfmt=4<\/strong> — XML
\noutfmt=11<\/strong> — PDF
\noutfmt=12<\/strong> — CSV
\noutfmt=13<\/strong> — True Excel (.xlsx)
\noutfmt=14<\/strong> — Text File (.txt)
\noutfmt=15<\/strong> — Optimized Excel (.xlsx)<\/p>\n