{"id":2163,"date":"2011-08-29T16:34:57","date_gmt":"2011-08-29T08:34:57","guid":{"rendered":"http:\/\/www.finereport.com\/knowledge\/design\/java%e6%8a%a5%e8%a1%a8%e8%bd%af%e4%bb%b6finereport%e5%ae%9e%e7%8e%b0%e5%8a%a8%e6%80%81%e6%98%be%e7%a4%ba%e5%8f%82%e6%95%b0%e6%8e%a7%e4%bb%b6.html"},"modified":"2018-09-11T19:38:28","modified_gmt":"2018-09-11T11:38:28","slug":"dynamic-para","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2011\/08\/29\/dynamic-para\/","title":{"rendered":"FineReport display parameter controls dynamically"},"content":{"rendered":"

Due to the needs of business, in many cases the need to achieve in a web report<\/a> such an effect: When a condition is met, certain conditions before the query is displayed, as shown below, select the annual report, showing in the drop down box control; select month Daily, year and month displays a drop-down box controls; select Daily, displays the date controls: as shown.
\n\"annual<\/a>
\n\"monthly<\/a>
\n\"daily<\/a>
\nHere we look at how to achieve these effects in Web reporting software<\/a> FineReport.\u3002
\nReport by visible controls (), invisible () attribute controls its visual and non-visual
\nvar [Widget] = form.getWidgetByName(“[ParaName]”); \/\/Get control via control name
\n[Widget].visible(); \/\/Set the control visibility
\n[Widget].invisible(); \/\/Set the control Invisible
\nSpecific steps are as follows:
\n1. Open report sample<\/b>
\nOpen Sample:
\n%FR_HOME%WebReportWEB-INFreportletsdocParameterDynamicSQLDynamicSQL.cpt<\/b>\u3002
\n2. Modify report dataset<\/b>
\nThe dataset amended as follows:
\nSELECT * FROM \u8ba2\u5355 where 1=1 ${if(type==”\u65e5\u62a5”,”and format(\u8ba2\u8d2d\u65e5\u671f,’yyyy-mm-dd’) = ‘” + date + “‘”,if(type==”\u6708\u62a5”,”and month(\u8ba2\u8d2d\u65e5\u671f) = “+ month + ” and year(\u8ba2\u8d2d\u65e5\u671f) = ” + year ,”and year(\u8ba2\u8d2d\u65e5\u671f) = ” + year ))}<\/b>
\nType parameter type is set to the default value daily, the parameter date set default values \u200b\u200bfor the string value 2010-01-03.
\n3. Reports table-like modification<\/b>
\nThe table-like style modified as follows:
\n\"Report<\/a>
\nSet to A3 forms, custom data, the actual value is displayed with the corresponding values \u200b\u200bwere: daily, date; monthly, years; annual, year.
\nAdd the following formula in cell B3:=if(type==”\u65e5\u62a5”,$date,if(type==”\u6708\u62a5”,$year+”.”+$month,$year))<\/b>
\n4. Report Parameters interface settings<\/b>
\nSet the parameter interface into the following styles:
\n\"report<\/a>
\nSet the control type parameter type drop-down box, custom value and the actual value is displayed values \u200b\u200bare daily, monthly and annual reports.
\nSet the parameters for the control type year drop-down box, custom values \u200b\u200band actual values \u200b\u200bare displayed for 2010,2011.
\nSet the control type parameter month for drop-down box, the value equation, fill in the actual value of the formula = range (1,6) can be.
\nSet the control type parameter date for date, the return value type is the default string.
\n5. JS Event<\/b>
\nTo the parameter type drop-down box controls to increase the edited event, the specific JS code is as follows: Report Controls js code
\n\"\u62a5\u8868\u63a7\u4ef6js\u4ee3\u7801\"<\/a>
\nNote: This code determine the type parameter value, if daily newspaper, only the date controls, if monthly, year and month are displayed controls, if the annual report, only the year controls.<\/b>
\n6. Save the report template<\/b>
\nClick on the preview page, the effect is as shown above.<\/p>\n","protected":false},"excerpt":{"rendered":"

Due to the needs of business, in many cases the need to…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2163"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=2163"}],"version-history":[{"count":1,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2163\/revisions"}],"predecessor-version":[{"id":4743,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2163\/revisions\/4743"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=2163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=2163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=2163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}