birt中做下拉框的二级级联

涉及表结构--Createtable公司表createtableDB_DEPT_COMPANY(compidVARCHAR2(20)notnull,compnameVARCHAR2(20));--Create/Recreateprimary,uniqueandforeignkeyconstraintsaltertableDB_DEPT_COMPANYaddprimarykey(COMPID);--Createtable公司部门表createtableDB_DEPT(deptidVARCHAR2(20)notnull,deptnameVARCHAR2(20),compidVARCHAR2(20))--Create/Recreateprimary,uniqueandforeignkeyconstraintsaltertableDB_DEPTaddprimarykey(DEPTID);addforeignkey(COMPID)referencesDB_DEPT_COMPANY(COMPID);一：配置数据源二：写第一个结果集的查询语句selectcompid,compnamefromdb_dept_companyunionselect'all'ascomid,'请选择'ascompnamefromdual三：写第二个结果集的查询语句selectdeptid,deptnamefromdb_deptwherecompid=?unionselect'all'asdeptid,'请选择'deptnamefromdual注意：在第二个结果集中要添加一个parameters参数对应第二个结果集中动态sql的？如果在创建第二个结果集中的Parameter时报错可以先把下面的CascadingParameters创建出来再去创建第二个结果集的Parameter(参数名可以任意)四：在ReportParameters中创建一个CascadingParameter选择MultipleDataSet%@pagelanguage=javacontentType=text/html;charset=utf-8pageEncoding=utf-8%%@tagliburi=/birt.tldprefix=birt%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML1.0Transitional//EN==Content-Typecontent=text/html;charset=UTF-8/linkhref=../css/main.cssrel=stylesheettype=text/css//headbodybirt:parameterPageid=report1name=page1reportDesign=report_demo_hulihui/report/CasCade.rptdesignisCustom=truepattern=framesetshowTitle=trueshowNavigationBar=truetableborder=1cellpadding=0style=border-collapse:collapsebordercolor=#DDDDDDwidth=80%bgcolor=#FFFFFFtrtdheight=24birt:paramDefname=compid=comp/birt:paramDef/tdtdheight=24birt:paramDefname=deptid=dept/birt:paramDef/td/tr/table/birt:parameterPage/body/html方法二：从上面的二开始不再创建两个结果集创建一个结果集selectc.compid,c.compname,d.deptid,d.deptnamefromdb_dept_companycleftjoindb_deptdonc.compid=d.compidunionselect'all','请选择','all','请选择'fromdual仍然要创建级联参数这次选择SingleDataSet%@pagelanguage=javacontentType=text/html;charset=utf-8pageEncoding=utf-8%%@tagliburi=/birt.tldprefix=birt%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML1.0Transitional//EN==Content-Typecontent=text/html;charset=UTF-8/linkhref=../css/main.cssrel=stylesheettype=text/css//headbodybirt:parameterPageid=report1name=page1reportDesign=report_demo_hulihui/report/CasCade.rptdesignisCustom=truepattern=framesetshowTitle=trueshowNavigationBar=truetableborder=1cellpadding=0style=border-collapse:collapsebordercolor=#DDDDDDwidth=80%bgcolor=#FFFFFFtrtdheight=24birt:paramDefname=comppid=compp/birt:paramDef/tdtdheight=24birt:paramDefname=depttid=deptt/birt:paramDef/td/tr/table/birt:parameterPage/body/html