回答：用单元格数据源

回答：你的横向的表头不是写死的吗，那你竖着再写死就行了，数据横向扩展

回答：[图片]

回答：已解决，单位是毫秒，1秒=1000毫秒

回答：SELECT * FROM (selectu.ID 用户ID,u.USERNAME ,u.REALNAME 姓名,rc.id 角色ID,rc.NAME 角色 ,rd.id 部门ID,d.NAME 部门from FINE_USER uleft join FINE_USER_ROLE_MIDDLE rm on u.id=rm.userId left join FINE_CUSTOM_ROLE rc on rm.ROLETYPE=2 and rm.ROLEID=rc.idleft join FINE_DEP_ROLE rd on rm.ROLETYPE=1 and rm.ROLEID=rd.idleft join FINE_DEPARTMENT d on d.id=rd.DEPARTMENTIDleft join FINE_POST p on p.id=rd.POSTID where 1=1 ${if(len(fine_username) == 0,"","and u.USERNAME ='"+fine_username+"' ") }) AJOIN (selectF.roleid,case when f.AUTHORITYTYPE='1' then '查看权限'when f.AUTHORITYTYPE='2' then '授权权限'when f.AUTHORITYTYPE='3' then '编辑权限'when f.AUTHORITYTYPE='4' then '数据连接管理权限'when f.AUTHORITYTYPE='101' then 'FineReport 模板认证权限'when f.AUTHORITYTYPE='102' then 'FineReport 模板查看权限'when f.AUTHORITYTYPE='103' then 'FineReport 模板填报权限'when f.AUTHORITYTYPE='201' then '业务包使用权限'when f.AUTHORITYTYPE='202' then '业务包管理权限'when f.AUTHORITYTYPE='203' then 'BI报表导出权限'when f.AUTHORITYTYPE='204' then 'BI仪表板分享权限'when f.AUTHORITYTYPE='205' then 'BI模板认证权限'when f.AUTHORITYTYPE='206' then 'BI模板查看权限'when f.AUTHORITYTYPE='207' then 'BI模板导出权限'when f.AUTHORITYTYPE='208' then 'BI仪表板分享角色控制权限'when f.AUTHORITYTYPE='209' then 'BI仪表板分享功能权限'when f.AUTHORITYTYPE='210' then 'BI仪表板公共链接功能权限' end AUTHORITYTYPE,case when f.ROLETYPE='1' then '部门'when f.ROLETYPE='2' then '角色'when f.ROLETYPE='3' then '用户'when f.ROLETYPE='4' then '职务' end 类型,a.ID,a.DISPLAYNAME ,a.SORTINDEX,a.PARENTID PARENTID0,b.PARENTID PARENTID1,c.PARENTID PARENTID2,d.PARENTID PARENTID3,e.PARENTID PARENTID4,case when a.EXPANDTYPE='1' then '平台管理系统节点'when a.EXPANDTYPE='2' then '首页'when a.EXPANDTYPE='3' then '目录'when a.EXPANDTYPE='5' then '链接'when a.EXPANDTYPE='6' then '文件'when a.EXPANDTYPE='101' then '上报流程'when a.EXPANDTYPE='102' then ' FineReport报表'when a.EXPANDTYPE='201' then ' BI报表' end 权限目录类型,case when a.DEVICETYPE='0' then '未勾选 'when a.DEVICETYPE='1' then 'PC 'when a.DEVICETYPE='2' then '平板 'when a.DEVICETYPE='3' then 'PC、平板 'when a.DEVICETYPE='4' then '手机 'when a.DEVICETYPE='5' then 'PC、手机 'when a.DEVICETYPE='6' then '平板、手机 'when a.DEVICETYPE='7' then 'PC 、平板、手机 ' end  适用平台, a.SORTINDEX 排序顺序from FINE_AUTHORITY_OBJECT aleft join FINE_AUTHORITY_OBJECT b on a.PARENTID=b.idleft join FINE_AUTHORITY_OBJECT c on b.PARENTID=c.idleft join FINE_AUTHORITY_OBJECT d on c.PARENTID=d.idleft join FINE_AUTHORITY_OBJECT e on d.PARENTID=e.id join FINE_AUTHORITY f on f.AUTHORITY=2 and (a.id=f.AUTHORITYENTITYID or a.PARENTID=f.AUTHORITYENTITYID or b.PARENTID=f.AUTHORITYENTITYID or c.PARENTID=f.AUTHORITYENTITYIDor d.PARENTID=f.AUTHORITYENTITYID or e.PARENTID=f.AUTHORITYENTITYID)where not exists (select 1 from  FINE_AUTHORITY f1 where f1.AUTHORITY=1 and (a.id=f1.AUTHORITYENTITYID or a.PARENTID=f1.AUTHORITYENTITYID or b.PARENTID=f1.AUTHORITYENTITYID or c.PARENTID=f1.AUTHORITYENTITYID or d.PARENTID=f1.AUTHORITYENTITYID or e.PARENTID=f1.AUTHORITYENTITYID) and f.roleid=f1.roleid and f.AUTHORITYTYPE=f1.AUTHORITYTYPE)-- and  f.roleid='old-platform-custom-1' order by a.PARENTID,a.SORTINDEX) B ON A.用户ID=B.roleid OR A.角色ID=B.roleid   OR A.部门ID=B.roleid

回答：在body里面加初始化事件setTimeout(function(){/*修改下拉按钮*/$(".fr-trigger-btn-up").css({"background-color":"#0b1d46","border-bottom-right-radius": "5px","border-top-right-radius": "5px","border": "0.5px solid #062c51","border-left-style": "none","height": "20px"});$(".fr-trigger-btn-over").css({"background-color":"#0b1d46","border-bottom-right-radius": "5px","border-top-right-radius": "5px","border": "0.5px solid #062c51","border-left-style": "none","height": "20px"});$(".fr-trigger-btn-down").css({"background-color":"#0b1d46","border-bottom-right-radius": "5px","border-top-right-radius": "5px","border": "0.5px solid #062c51","border-left-style": "none","height": "20px"});//适用于v.11版本和v.10的新自适应插件v10原版可以引用css文件实现，js代码为：$('<link rel="stylesheet" type="text/css" href="/webroot/help/css/style1.css"/>').appendTo('head'); 

回答：把图的大小放大一点，有可能是被挤下去了

回答：日期字段的格式转换一下再排序试试

回答：建议是同步到同一个数据库