回答:[图片]
回答:帆软讲堂 - 帆软在线视频课堂 - 帆软社区http://bbs.fanruan.com/course-2.html
回答:'${memberId}' oa登录人员idselect * from ORG_UNIT t left join ORG_MEMBER m on t.ID=m.ORG_DEPARTMENT_IDleft join ORG_UNIT u on u.ID=t.ORG_ACCOUNT_IDwhere m.id= '${memberId}'
回答:where 1=1 ${if(isnull(userId),""," and function1('"+userId+"')")}把函数结果拼到sql where 1=1+sql(数据源,"select function1('"+${userid}+"') from 表 ",1,1)
回答:公式的值会扩展,但是父格约束不了公式里面的值。把那三个值放到单元格上,把单元格隐藏了,取单元格的值
回答:select * from imaa_t where 1=1 and ${if(isnull(material),""," and ima001 in ("+material+")")}勾起
回答:条件属性,判断那一列有空值就把行高设为0;或者直接在sql里面用 is not null 过滤
回答:${if(fr_username = 'admin',""," and 姓名='"+fr_username+"'")}
回答:http://help.finereport.com/finereport9.0/JDBC连接数据库-http://help.finereport.com/finereport9.0/doc-view-101.html
回答:[图片]
698
698
1
10