最近刚接触到birt报表开发,整理了下使用脚本拼接参数的问题。如果需要使用脚本拼接参数,在报表设计中选中自己所建的数据集,然后点击脚本,选择beforeOpen添加脚本。
var sqlWhere = " where 1=1 "; //拼装where
var sqlGroup = " group by ";//拼装 group
var sqlOrder = " order by ";// 拼装 order
//接收页面传过来的参数
var type_code = decodeURI(params["type_code"].value); //存款类型
var bank = decodeURI(params["bank"].value); //开始日期
var detial_type= decodeURI(params["detial_type"].value); //类型细分
//参数的拼接
//存款产品
if(type_code == "yes"){//全选
sqlGroup = sqlGroup + "SAVING_DEPOSIT,SAVING_NAME, ";
sqlOrder = sqlOrder + "SAVING_DEPOSIT,";
}else if(type_code == "no"){//不显示数据列
sqlGroup = sqlGroup + "SAVING_DEPOSIT,SAVING_NAME, ";
}else {//选择那个显示那个
sqlWhere = sqlWhere + "AND SAVING_DEPOSIT in " + type_code;
sqlGroup = sql