回答:select aa.*,bb.pronivce_num from (
select pro_project.name as proName,
pro_user.name as userName,
pro_project.stage_status as stageStatus,
pro_province_city.name as pronivce_name,
i.name as city_name,
t.name as county_name,
FROM_UNIXTIME(pro_project_appraisal.time,"%Y-%m-%d %H:%i") as appraisalDate,
pro_project_appraisal.*
from pro_project_appraisal
join pro_project on pro_project_appraisal.pid=pro_project.id
join pro_user on pro_project_appraisal.uid=pro_user.id
join pro_province_city on pro_project.province_id=pro_province_city.id
join pro_province_city as i on pro_project.city_id=i.id
join pro_province_city as t on pro_project.county_id=t.id
where pro_project.status=1
and pro_project_appraisal.status!=0) aa
left join (select pro_province_city.name as pronivce_name,count(*) as pronivce_num
from pro_project_appraisal
join pro_project on pro_project_appraisal.pid=pro_project.id
join pro_user on pro_project_appraisal.uid=pro_user.id
join pro_province_city on pro_project.province_id=pro_province_city.id
join pro_province_city as i on pro_project.city_id=i.id
join pro_province_city as t on pro_project.county_id=t.id
where pro_project.status=1
and pro_project_appraisal.status!=0) bb
on aa.pronivce_name=bb.pronivce_name
回答:在审核按钮的js事件前面增加一个参数,然后参数值获取单元格的值,然后在js里面用这个参数,你试下是否可行
回答:在between前加上and
回答:DATEINMONTH(MONTHDELTA(today(),-1),-1)
回答:1、可以先alert一下这段js执行的SQL,直接在数据库执行这个SQL是否可展示;2、然后注意关掉安全防护
回答:参数面板隐藏-https://help.finereport.com/doc-view-1833.html
回答:设计器 服务器--》服务器配置--》引用JavaScript
回答:document.title = "决策报表标题";修改标题-https://help.finereport.com/doc-view-975.html帮助文档包含普通报表和决策报表标题修改方式
回答:在报表把数据处理一下,根据公式和父格实现报表展示问题.cpt
回答:可以考虑用remoteEvaluate()来实现,里面用SQL韩式,拼接调用存储过程的语句来实现注意:需要把决策系统的 登录决策系统,进入管理系统>安全管理>安全防护>脚本调用公式限制 关闭
524
524
3
10