如果列是查询条件的话,可以定义报表参数,
select obj.*,cot_emps.emps_id,cot_pan_pic.pic_img,cot_dept.dept_name,cot_pan.*
from cot_pan_ele obj ,cot_pan_pic,cot_pan,cot_emps,cot_dept where 1=1
and obj.id = cot_pan_pic.fk_id
and obj.panId = cot_pan.id
and cot_pan.add_person = cot_emps.id
and cot_pan.deptid = cot_dept.id
and $P!{STR_SQL}
STR_SQL可以是 obj.xxx = 11 and obj.xxxx = sdfsd等