{"id":86,"date":"2006-02-21T12:41:04","date_gmt":"2006-02-21T03:41:04","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_espress\/archives\/86"},"modified":"2006-02-21T12:41:04","modified_gmt":"2006-02-21T03:41:04","slug":"%e3%83%9b%e3%83%bc%e3%83%9f%e3%83%a5%e3%83%a9%e3%83%bc%e3%83%91%e3%83%a9%e3%83%a1%e3%83%bc%e3%82%bf%e3%82%92%e3%82%b5%e3%83%96%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88%e6%b8%a1%e3%81%99%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_espress\/archives\/86","title":{"rendered":"\u30db\u30fc\u30df\u30e5\u30e9\u30fc\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u6e21\u3059\u65b9\u6cd5\u3010Java\u5bfe\u5fdc\u30ec\u30dd\u30fc\u30c8\u30fb\u5e33\u7968\u30c4\u30fc\u30ebEspressReport\u3011"},"content":{"rendered":"<p>Q) \u30de\u30cb\u30e5\u30a2\u30eb\u306b\u306f\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u3067 <br \/>\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u304c\u3001<br \/>\u30db\u30fc\u30df\u30e5\u30e9\u30fc\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3059\u3053\u3068\u3082\u53ef\u80fd\u306a\u306e\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n<p>A) \u5b58\u5728\u3059\u308bAPI\u3067\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u306b\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<br \/>\u3000\u3000 API\u3067\u306f\u3001\u30e1\u30a4\u30f3\u30ec\u30dd\u30fc\u30c8\u3067\u306e\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001<br \/>\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u306e\u5185\u90e8\u306e\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u65e2\u306b\u5171\u6709\u3055\u308c\u307e\u3059\u3002<br \/>\u3000\u3000 <br \/>API\u30e1\u30bd\u30c3\u30c9 : setSubReportFormulaParameter()<\/p>\n<p>\u4f8b:<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>QbReport report = new QbReport(applet, &#8220;Templates\/main-sub- queryparam.rpt&#8221;, new Object[]{&#8220;ARC&#8221;});<br \/>SubReportObject[] subReports = report.getSubReports();<\/p>\n<p>QbReport subReport = (QbReport)subReports[0].getSubReport(report);<br \/>Vector formulaParam = subReport.getFormulaParameters();<\/p>\n<p>Vector params = new Vector();<br \/>for (int i = 0; i {<br \/>Parameter param = (Parameter)formulaParam.elementAt(i);<br \/>if (!param.isShared()) params.addElement(param);<br \/>}<\/p>\n<p>Parameter[] paramArray = new Parameter[params.size()];<br \/>for (int i = 0; i {<br \/>paramArray[i] = new Parameter();<br \/>paramArray[i].copy((Parameter)params.elementAt(i));<br \/>paramArray[i].setValue(new Integer(10));<br \/>}<\/p>\n<p>Hashtable table = new Hashtable();<br \/>table.put(subReports[0].getFileName(), paramArray);<br \/>report.setSubReportsFormulaParameter(table);<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>\u203b \u4e0b\u8a18\u306e\u30b3\u30fc\u30c9\u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>Parameter parameters=report.getAllParameters();<br \/>for(int i=0, i {<br \/>if !(parameters.get(i).parent().equals(Param.Root_REPORT))<br \/>&#038;&#038; (parameters.get(i). &gt; FormulaParam())<br \/>{<br \/>Parameters.get(i).setValut(&#8230;.)<\/p>\n<p>}<br \/>}<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>\u3053\u306eAPI\u30e1\u30bd\u30c3\u30c9\u306b\u3064\u3044\u3066\u3001<br \/>\u300chttp:\/\/www.quadbase.com\/eres\/apidocs\/index.html &gt; <br \/>QbReport &gt; setSubReportFormulaParameter()\u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Q) \u30de\u30cb\u30e5\u30a2\u30eb\u306b\u306f\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u3067 \u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u304c\u3001 \u30db\u30fc\u30df\u30e5\u30e9\u30fc\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3059\u3053\u3068\u3082\u53ef\u80fd\u306a\u306e\u3067\u3057\u3087\u3046\u304b\uff1f A) \u5b58\u5728\u3059\u308bAPI\u3067\u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u306b\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\u3000\u3000 API\u3067\u306f\u3001\u30e1\u30a4\u30f3\u30ec\u30dd\u30fc\u30c8\u3067\u306e\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u3001 \u30b5\u30d6\u30ec\u30dd\u30fc\u30c8\u306e\u5185\u90e8\u306e\u30d5\u30a9\u30fc\u30df\u30e5\u30e9\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u65e2\u306b\u5171\u6709\u3055\u308c\u307e\u3059\u3002<br \/>\n <a href=\"https:\/\/www.climb.co.jp\/blog_espress\/archives\/86\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-espressreport"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":0,"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_espress\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}