MAXIMO5.2明细报表工具栏按钮替换为运行报表
来源:互联网 发布:单片机高级证书 编辑:程序博客网 时间:2024/05/17 03:12
--两票中明细报表工具栏按钮替换为运行报表
--select * from sigoption where app='TICKET'
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'TICKET' and description = '两票明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'TICKET' and description = '运行报表';
commit;
--工单跟踪
--select * from sigoption where app='WOTRACK' AND description IN ('工单明细汇报','运行报表');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'WOTRACK' and description = '工单明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'WOTRACK' and description = '运行报表';
commit;
--采购
--select * from sigoption where app='PO' AND description IN ('采购单明细汇报','运行报表');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'PO' and description = '采购单明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'PO' and description = '运行报表';
commit;
--采购申请
--select * from sigoption where app='PR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'PR' and OPTIONNAME = 'DETAILREP';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'PR' and OPTIONNAME = 'RUNREPORTS';
commit;
--发放和转移
select * from sigoption where app='INVISSUE' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'INVISSUE' and OPTIONNAME = 'RUNREPORTS';
commit;
--标准作业计划
select * from sigoption where app='JOBPLAN' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'JOBPLAN' and OPTIONNAME = 'RUNREPORTS';
commit;
--接收
select * from sigoption where app='RECEIPTS' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'RECEIPTS' and OPTIONNAME = 'RUNREPORTS';
commit;
--库存控制
select * from sigoption where app='INVENTOR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'INVENTOR' and OPTIONNAME = 'RUNREPORTS';
commit;
--库存
select * from sigoption where app='ITEM' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'ITEM' and OPTIONNAME = 'RUNREPORTS';
commit;
--select * from sigoption where app='TICKET'
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'TICKET' and description = '两票明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'TICKET' and description = '运行报表';
commit;
--工单跟踪
--select * from sigoption where app='WOTRACK' AND description IN ('工单明细汇报','运行报表');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'WOTRACK' and description = '工单明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'WOTRACK' and description = '运行报表';
commit;
--采购
--select * from sigoption where app='PO' AND description IN ('采购单明细汇报','运行报表');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'PO' and description = '采购单明细汇报';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'PO' and description = '运行报表';
commit;
--采购申请
--select * from sigoption where app='PR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = null,toolbarposition = null,IMAGE=NULL where app = 'PR' and OPTIONNAME = 'DETAILREP';
update sigoption set toolbargroup = 3,toolbarposition = 3,image='nav_icon_detreport.gif' where app = 'PR' and OPTIONNAME = 'RUNREPORTS';
commit;
--发放和转移
select * from sigoption where app='INVISSUE' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'INVISSUE' and OPTIONNAME = 'RUNREPORTS';
commit;
--标准作业计划
select * from sigoption where app='JOBPLAN' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'JOBPLAN' and OPTIONNAME = 'RUNREPORTS';
commit;
--接收
select * from sigoption where app='RECEIPTS' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'RECEIPTS' and OPTIONNAME = 'RUNREPORTS';
commit;
--库存控制
select * from sigoption where app='INVENTOR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'INVENTOR' and OPTIONNAME = 'RUNREPORTS';
commit;
--库存
select * from sigoption where app='ITEM' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = 3,toolbarposition = 1,image='nav_icon_detreport.gif' where app = 'ITEM' and OPTIONNAME = 'RUNREPORTS';
commit;
- MAXIMO5.2明细报表工具栏按钮替换为运行报表
- SSRS 2008 明细报表
- 重构 水晶报表工具栏自带按钮
- web程序发布后,水晶报表工具栏不显示按钮
- 报表自定义工具栏
- 为Odoo安装PDF报表运行环境
- 自定义水晶报表外观、工具栏、样式设置、除水晶报表的的公司LOGO 、替换图标等,非常实用!
- 【分享】自定义水晶报表工具栏导出按钮事件WinForm & WebForm版
- 帆软报表自定义在原工具栏上增加按钮导出其他模板
- 报表
- 报表
- 报表
- 报表
- 报表
- 报表
- 报表
- 报表
- 报表
- 职业生涯12个致命想法
- 《三国志11》版明星头像
- MaintainScrollPositionOnPostback
- 美国〈国家地理〉镜头中的极致之地
- 创建跨多列、多行表头的DataGrid
- MAXIMO5.2明细报表工具栏按钮替换为运行报表
- eclipse 工具
- 关于局域网内的数据库同步备份问题
- PHP安全(三)
- 创建跨多列、多行表头的DataGrid
- 在DataGrid中添加一个合计字段
- ASP.net运行流程
- 这一段遇到的 oracle 的问题
- 小技巧: 当ACE_Svc_Handler关闭时使用的默认行为