回答:看一下字段是不是char(10),改成nvarchar(10),大致就是固定长度改为可变长度
回答:再点一次
回答:如果说的是查询的结果的话,数据集参数就这样设置列名 like ('%"+参数+"%'),如果是控件查询的话就只能用下拉框。
回答:var $iframe = $("<iframe id='inp' name='inp' width='100%' height='100%' scrolling='no' frameborder='0'>"); // iframe参数的命名及宽高等
$iframe.attr("src", "http://localhost:8075/webroot/decision/view/form?viewlet=%25E6%258E%25A7%25E4%25BB%25B6%25E6%25B5%258B%25E8%25AF%2595.frm"); //childtest.cpt为点击查询时,对话框中显示的子报表
var o = {
title: "标题",
width: 300, //调整对话框宽度
height: 180 //调整对话框高度
};
FR.showDialog(o.title, o.width, o.height, $iframe, o); //弹出对话框
回答:select VerifyLog.value('(/root/row/operationDate)','varchar(max)')
from Tecul_WFVerifyRecord where itemcode='PP2021092385-1'这样就能动态的查出最后一行operationDate的值了
回答:我自己解决了,在条件显示里设置就可以了,像我这个系列有四个,就拆成了两个两个算。具体如下:代码分别为:function sumLabel(){ const point = this; const points = point.points; const validPoints = points.filter( (point) => point.isVisible() ); if(point == validPoints){ let value = 0; for(let i = 0; i < validPoints.length/2; i++){ value += validPoints.value; } return value; } else { return ""; }}function sumLabel(){ const point = this; const points = point.points; const validPoints = points.filter( (point) => point.isVisible() ); if(point == validPoints){ let value = 0; for(let i = (validPoints.length/2); i < validPoints.length; i++){ value += validPoints.value; } return value; } else { return ""; }}
回答:百分比的话字样式-标签里有,吧百分比勾上就可以了,颜色的话在系列里自定义
回答:setTimeout(function() { AutoScroll(); //此处根据实际报表需求添加REPORT块名称 //定义需要跑马灯效果的报表块名字,兼容大小写}, 2000);function AutoScroll(e) { for (i = 0; i < e.length; i++) { (function(e, i) { scroll(e, i); })(e, i); }}function scroll(e, i) { var $report = $("div.toUpperCase() + "]"); //获取对应report的div元素 var $scroll; if ($report.find(".frozen-center").length != 0) { $scroll = $report.find(".frozen-center"); } else if ($report.find(".scrollDiv").length != 0) { $scroll = $report.find(".scrollDiv"); } else { $scroll = $report.find(".reportContent"); } //判断是否冻结以及是否安装自定义滚动条插件 var flag = eval("window.flag" + i); //设置全局flag,控制悬停 if (interval) { clearInterval(interval); } //清除定时器,避免越滚越快 var interval = eval("window.interval" + i); $report.find("#frozen-center").css('overflow-x', 'hidden'); $report.find("#frozen-center").css('overflow-y', 'hidden'); $report.find("#frozen-north").css('overflow-x', 'hidden'); $report.find("#frozen-north").css('overflow-y', 'hidden'); //冻结情况下隐藏滚动条 $report.find(".reportContent").css('overflow-y', 'hidden'); $report.find(".reportContent").css('overflow-x', 'hidden'); //非冻结情况下隐藏滚动条 flag = true; $scroll.mouseover(function() { flag = false; $report.find("#frozen-center").css('overflow-x', 'hidden'); $report.find("#frozen-center").css('overflow-y', 'auto'); $report.find("#frozen-north").css('overflow-x', 'hidden'); $report.find("#frozen-north").css('overflow-y', 'auto');//鼠标悬浮时避免滚轮功能被屏蔽,显示滚轮 }) //鼠标悬浮,滚动停止 $scroll.mouseleave(function() { flag = true; $report.find("#frozen-center").css('overflow-x', 'hidden'); $report.find("#frozen-center").css('overflow-y', 'hidden'); $report.find("#frozen-north").css('overflow-x', 'hidden'); $report.find("#frozen-north").css('overflow-y', 'hidden'); }) //鼠标离开,继续滚动 var old = -1; interval = setInterval(function() { if (flag) { currentpos = $scroll.scrollTop; //获取距顶部距离 if (currentpos == old) { $scroll.scrollTop = 0; //若已到达底部,则重置 } else { old = currentpos; $scroll.scrollTop = currentpos + 1.0; //若未到达底部,则向下移动1.5像素 } } }, 100); //以25ms的频率执行}
回答:select a,b from table where c=1union allselect 1 as a,2 as b where not exists(select 1 from table where c=1)
回答:我自己解决
11
11
56
10