请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
afr751116(uid:36304)
职业资格认证:FCA-FineReport
  • 参照批量删除填报应用分享 http://bbs.fanruan.com/thread-70864-1-1.html 做了一个批量删除跟复选框的按钮,位置在下图: 44680 两个按钮的设置 44681 44682 44683 var $span = $('.fr-checkbox-checkon'); //定义选中的复选框 var darray = ; var $tds = $("td").has($span); //定义选中复选框的单元格 for (var i = 0, len = $tds.length; i < len; i ++) { //遍历选中的单元格 var id = $($tds).attr("id"); //给选中的单元格加上id的属性 if (id) { darray.push(id); //将选中的id放入到数组中 } } contentPane.deleteReportRC(null,darray); //第二个参数为批量删除的选中行 contentPane.writeReport(); 但是当我选择了之后,点批量删除,成功删了选择的行,但是提示老是失败,到底是哪的问题?从最终看是成功删了? 44684
  • 本帖最后由 afr751116 于 2016-9-14 21:04 编辑 做了个填报的报表,用自带的删行的报钮,一行一行的删除行,可以通过数据校验。 但是我像帮助那样做了个批量删除, 一个复制框,一个普通按钮做批量删除。 这样的删除方式在数据校验的时候,还是认为被我删除的那些行数还在,通不过,有什么办法,可以做到批量删除跟那个一行一行删一样的效果?
  • 本帖最后由 afr751116 于 2016-9-14 14:50 编辑 像下图的单元格,本来小数是 4位的, data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYQAAACiCAYAAABBP7pMAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAA9gSURBVHhe7d1BqB3VGcDx85IIL4hgNuIDuxBUqiULU7qIILQBQXTlotsuDK6KQnEljauqi4JI07oSW0SKILRdFNKFIK7qQklMpQkx2lgqedGNAQN5YJLb+b57zrxz586ZOTPvzL13zv3/YDLznTl37pzJzHxzZu69b2NSMACAtbfPjgEAa46EAABQJAQAgCIhAAAUCQEAoEgIAABFQgAAKBICAECREAAAioQAAFAkBACAIiEAABQJAQCgSAgAAEVCAAAoEgIAQJEQAACKhAAAUCQEAIAiIQAAFAkBAKBICAAARUIAACgSAgBAkRAAAIqEAABQJAQAgCIhAAAUCQEAoEgIAABFQgAAKBICAECREAAAioQAAFAkBACAIiEAABQJAQCgSAgAAEVCAAAoEgIAQJEQAACKhAAAUCSEhN5/74ydirOxsVEOvmrsNNVPUd6m2r7QcrqU+2V18+rU1RWh8pRO2W0Qeq8u5X5Zdd6qcu1PLbQN/Hio7ZNiv67TVD/0mmWQ9rt1IiEktGPHsSaTSTn4qrHTVD9FeZtq+0LL6VLul9XNq1NXV4TKU9q049B7dSn3y6rzVpVrf2qhbeDHi9o+TesSKq/TVD/0mmVx60RCSGiog2VV5N6+GF2Tfm7Wvf25IyEAHax7Usyx/ST5XSQEoANOHvkhye8iISSU+8li3U+GgpMHckZCSCj3g4WTAUmRi4K8kRCADugh5Ickv4uEAHTAySM/JPldJISEcj9ZrPvJUHDyQM5ICAnlfrBwMiApclGQNxIC0AE9hPyQ5HdtTFbtO9QjJr8Jcuyxh22Un9zb1+bDL3fM9RvGHDxg1np87L680sK679d++0kIAbKRJHP6uz7xesfm/gfNwWJ0vRjWenzxfPFv+u1LvPyYhBBw5asrdireufPb5qEHt2yUn9zb1+bSjTv1CvnDT7fjT54ZjZ98eEvb/9Dm1SLKx7rv1377SQgBV69cNTs3ipxZdJNNcRBsHthsjU9/esk8dLjYsJH1xxbn3r62+PTOpp4c3z+zbY4fPVRMrY83P9oxRw/fqe2/98DVJNtzVeLTRYJ/5PC9yZY3tthvPwkhgB7CPHoIuz2E5x8rtoM9uExxcBnvYMsxfukfl+ghZMpvP58yCpGDoSCZVEXExSHUqb4YU5x7+0RTrLdPXPnmtHxdxvpA2Y5VzfYRxOOOSQghcmVU0G6ViIhl03apL8YU594+0RTrvfSyfHowyfzN4mDKPZZ2++1PsT0F8WrFJIQAORhUcTAIYuLZHoIbTydyjw8eODjb/gTbU61ALKfElMsTY4r99pMQAlJnXuLxx3NXyHJwrcn4+o3rlR5S+u2rlhDLqTDl8sSYYr/9JIQQORgKfTNtn9eLVY5zb59oiuvuoa/LmGcI01HuMQkhZI+Zts/rxSrHubdPNMUzPYQ1wzOE6Sj3mI+dBvA9hPmY7yHsfg/h10/dW0xNHfl9Mb8YF7UXOv7ns8U/C/Ly36/wPYRMY7/99BACdGOJYuOJlPHWD7bm5h/aOqTlW1vTzwO3vd6v7y/PxTJftSw/VL/p/YX/elGd794vZnnu/av13frKuOn1YhFxqIegJ+my3mLjRRn6GULT/ikkru4fKkE83Z67sbxPaP+t29+b6jfF1foSL2N/l/a79SchhEgmLUgmVRGxbOK2+roTCG++lG1vb5vt/22bb7e/ndYJvN7Ffn0Zy3x5nYtlvsRNyw/VVzXvX22fLsfx6vvvV9apWZ7Quvb9/fqu3K2fK29aPzFkPHMP3TPdLsWVVnHFrh/ZtLGQsVzJn/7Vblyd78dSr66+xLJ8Gfv1nY2NDTs1K1Te1ZDPEPT/umH/dLGrrwaKdV1q9keZX06LiPoi9H6unh+79vvLaVvfVLGsvyAhhPTMtG315T9bRSxPrFJcbV/ZFmHry5WGltu4rb2lamyV9a2m9RNDxqEegnC3b6pX8lIut5SOvDY9oYeu9GUs86Vetb4rf6RmOWLoZCCW/QxBrpxlX0q1vFBcqonr9vdSIA6+n+Vit+zQ/NblJYpJCAGpMm9MLDuDi92VQtvrpZ4bRFv9wWKrGpfr1uH1ri0zivoz5W3LGzAO9RCEnKyFf+UvycAv12cN3nw5FP24bVxXf1GW/T2EIXsK0+06jd2VssTyfn7si65f835ST9rjYuHmy7ym+UPEfvtJCAGpM29MrDtU9UohUF/quUFeF7N8lTq2/Ni1Q9et5p6rcLFb/7JnYblyd2VY2uv67iHu+wxBruj9HkRbfYnrehyiWi69gLrPhYTK+1rG9xD8/cftH237U594uv1n51d7uuV8K7p+JW7r6cg8GWR5qmV5KWK//SSEkD1m2q6vdyfRmPq643Vcfoq4rn0lL/bXr1SzPCGxHgT2yqpUzJfy8krJalo/MWTc9gxBVK/k5Z6/9AykpyCJoTrfj6Wee4ZQ7Vm4Zwh++aKSgRjyGYIKxNX//1Ki5dfFeiwGrvRLkfXrXq8XOsXgplW1vtW2vNQxCSFkj5m2y+t1h5KTqI1VS/0uy1cJ4rr2lSLj6uv9KyF/O/hXgl23jxogbnqGUL2Sd2O55y/q5k+352zsniFU67tnCNVyOfnL4KadUHlfy3qGUF55VyVafvD9AvNLkfWrsdR1g4vFXM/Halte6piEEJA687rYXRG4sZsvsT9U6/vLk53IryuxzK8r71Nf+O8n6mJ5jZCxmy9XSjPL9K6ctH5leX59//3dPWNXXvf+aoFx0zME/4o/diyHoh9Lz8DFrmchsd+z8MulF+AG4Y/ryvdiyGcIdfthOd9y+0PslXiXePr/YOOCvy4yCJnvpmUcXT/w/q6eG/v7uwxlzyhi/cVeYmm/Ww++mBbA30OYx99D2P17CP4X0+TK3d3bF+WVfHGwycnckRO5XIm5k78fV+trz6KI/fpCyl19SQ7C7wH4h3OovI8Tf+PvIeTKbz8JIeDKlSIh6MHY7xt/MfXHFq/7NzrP7Uy/qTv9i2nFlJ1/7O07db6cpOVkLeWLiE/9/EoRp2tfU/zmmevm6OEtbb98Uzn18pcZr/038L32c8sopNg4QjeeiIilE9alvhhTnHv7RFPcdA9dT9Z2vKh4Ou7fHhEbL+sZAvFiY3oIAfyW0XzMbxnt/pbRL48eSr78VY7fPGP4LaNMY7/9JIQAniHM4xnC7jOE4z+RU+P6+MNH13mGkCm//dwyCpFMWpBMqiLiIt92qi/GFOfePtEUL+Nz+KsSL+t7CMSLjekhBNBDmEcPYbk9hP3ffGNuO/dvs/PTn9mSxaGHkC96CBFSZ17i8cdDfQ5fxMT7v7xkbn/rj5oYUixPRcb8TeV8Y7/9JIQAfeAiiisiQUzsf8omxfJUh/i28+fMxrVr5o5Xf5tkeSoy5m8q5xv77SchhOwx0/Z5vVjlOPf2iaZ42ffQD/z3y+nkf74wt7/9J51OuXwRinmGMB3lHvMMIYBnCPN4hrD7DEFPjsWwyPGLr/7C7L9pL/EKf3nqefPp/T+Ofv1exzxDyJPffhJCAN9DmI/5HsL0ewgxJ8/U47vOfWJ++Bv7WxXWjdvvMP/63Z/NtWIcu5wUY76HkFfM9xAinHrvzPTeWjEwZizjQ/c/qFfIevtkweNDp/5q7ntbfvxo1tUfHTEXT7wavZwUY3PpfNT2Yjy+MQkhIUkiTzz2sI3yk3v7YrxfbINjS9gGN194wUw++MBGs/Y984zZ9/TTNhrWsto/pBzb1IXffh4qJyQZNme5ty+GXEktw+Tzz+3UvFtvvGEmZ87YaFjLaj8Wg4QAdLCUpCh/A8D+HYCQmy+9ZMx339loODleFKx7kvPbT0IAOljGyWNy8WJxxr9po4DLl83NV16xwXByPHmue8/Xbz8JIaEuB4v7E4f+EKtaN7SMruVtqu0LLccvr86r01Y3ZhmL4g6e0DqHyvdi8skndqqZPGO49e67NhrGUCfP0Hbz45TbtE3delQHp66sSV19v6w6bxHce5IQEup6sMjzfH+IUd1RJPaX4eZ3LY/ht69pOX55m7b16bJ+iyBJMbTObW3pS3sIkW699poxHep3NUQPoW17ptqOsULv56+jDCK07iFN9f1yGRbJvR8JAYNxO39OhrpCbjI5e9ZOxbnx8suDPU9YRvvFkPtSNcnlts+28dtPQlgi2cndEGOVTrD+eqRar+p2WKX2OnLwhNouY4ndkGLdJ6dPG/P99zaKdOGCuXnypA3SGqKHEMNt2yHEJjn//7avpn3EL18kv/0khIS6HiyyM7ihbSeo7jzLUNe+0HrFrq9re7X+KrS3Tt1tM8fFbpB4ryZffGGnImxtmY0nnzT7X3zR7D9+3Bamtcgegr8N3bZNsU37SvF/69pRt5xQ+SKREBLqcrDIf3pXspO4HWUZO0y1fbIOfdpR5Q6CqmW3t45Liqna3kZ7CJEOvPWW2X/ihNl44glj7r7blqa16B7CIrZxjKHXY1XayTeVgRV287nnjLnrLrPvyBGzUQw3nn3WmK++snNn7X/9da0D9EVCAEbk1smT5tY779holtwq0t4B0BO3jIAR2ff443Zq3uTrr+0U0A8JARiTBx4w5p57bDBr8tlndgroh4QAjMy+Rx+1UxXXrtkJoB8SAjAyodtGk48/tlNAPyQEYGwabhst4hdPkS8SAjBCodtGXX73CKgiIQAjFLxt1OWbzUAFCQEYo9BtIx4sYw9ICMBI1d026vJTF0AVCQEYqbrbRhMeKmMPSAjAWNXdNrpwwU4A3ZEQgBGr/bRRyx/kB0JICMCI1d42IiGgJxICMGY1t4346Cn6IiEAIzd324geAnoiIQAjV71txLeV0RcJARi7ym2jyeXLdgrohoQAZGDmthEJAT2REIAMzH3aiD+Wgx5ICEAOqreN+E0j9EBCADLh3zaanD1rp4B4JAQgEzO3jfhNI/RAQgBy4d024qOn6IOEAGTE3Taa8CN36IGEAGSkvG3ELSP0QEIAcuLfNuKP5aAjEgKQmfLTRnz0FB2REIDMuNtG/OopuiIhALmxt434uwjoioQAZEhvG5EQ0BEJAciQ3Daa8HtG6GhjUrDTAIA1Rg8BAKBICAAARUIAACgSAgBAkRAAAIqEAABQJAQAgCIhAAAUCQEAoEgIAABFQgAAKBICAECREAAAioQAAFAkBACAIiEAABQJAQCgSAgAAEVCAAAoEgIAQJEQAACKhAAAUCQEAIAiIQAAFAkBAKBICAAARUIAACgSAgBAkRAAAIqEAAAoGPN/prpX/IS9744AAAAASUVORK5CYII= 但是我使用了格式,使它成为整数 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQwAAAD0CAYAAABuOhhTAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAABWnSURBVHhe7d1BaCTXmcDxT4sDMvigAR9akIB7sMFtYrBEFiSDD9Hgw8inVbBhR7esswfP2ODMXnYxOQSGOSSywR5lIWvvQkA22KAcjGUIjHwwSIKEkQ9m2mDjHtiAdDCMDoYRrGH2fa/rtapLVa2qmuqq96T/r928ftXVpRpZ7+uvvq56PXHfEADI4R+iFgBORMAAkBsBA0BuBAwAuREwAORGwACQGwEDQG4EDAC5lTpx69r1a9JqtWT60Wk5d+6cXTb50KTIQ/328IdDkR9EOj/t2Od8svbBmrQfa9t91X2kPbntfdOT9uPmd5ZzfVrzO/t7T5ZfXDYdv0w+YsbpAyiVYdjgoL8c9X9RkDA3pW2875uHH3q4/8DtP+3JrRsMijZXq2+mp1GpgGEzCP0jUj/q9yfNzUn2fdL6cWuQAdHma9097/q0h9J52r/sugqlDklWfrciU1NTMt0yhySPnJPJh6PgoEHE3DVYHB6aX5qHhyS6X5ufbcrdg7uDd07NOu79cI8+/Qfqazv16JTMPj1rWx896CHJmathAGcZNQwAtTlzNQwA5VWWYcQl+wBOBy9qGO64aveLXdnr7cned3u2DyCdFlj1E7+F5xb64y2nRoqeaZ+SuNqFDRrmdnB4IDM/nYleMZr+IzY+3pDJyUmZnfG3wgxU4b3/ee+BT+rST/v0hLre//Zk8eJitPRkjRQ9q65haGahwWLh+QWCBU4/PZw3d5eJl2n1zbn9ZLt/ekCNvKhh6GGIZhbAWaCHE3bwG3bwm1vZft0qyzCcMv8YrVmQWeCssCd9GXpYofTwXZXt16myDOOBzsNwwecEExMT0aO+ZD9NnnWAWpm/dx3s9s31Adu6eVHDGASfDGUChaM1XYIGvBL9vd897NcfdPCrsv06eVHD0GO6UZIf5Iz6YEeDQ/I+ajlQt8G1J+bmDk/K9uvmRQ3D/RLSJAd4crAnn1caUE66A02xf+/mDTfZbm5vyuqbq/L7P/xe3vvDe0OtLt/a3jr+upp5X8NIDnDX1wARfy7ZniTvekDltIbh3lSjcaT91lTLfgCwd2dPune6Q639YGBqamj9JgRTw3AD3GUS2o9nFUn6XNYdaJQb9If6tmpuUU1i+ifT8ot/+oVdFs/Uta/L9fn4+q6tk/c1DB3g8WzgpEDh6HrJu1sONMn+vbuxnmg7T3Rk8eeL/TfdaJwtPr9ol1vJ19XM+xqGG+DxwFFm0CcDD9AU/XtPZgrx/uw/ztoTGXUcDR6PWL9O3tcwdKC7jCL+OItbJ3lPew5ohP69u8MS9+aa6Ov1IW/8xxs2u7Ay1q+b9zWMeFaRzBC0rwM/vtytF7+PWg7UTv/ezd2Oowdta+Z9DUPp4HZZQXyguz7ZAkKif+9usGs7VOAs2K+bFzUMveT24KB/fnxSPFDEg4NbprKChnst4BNXs7t3r9/evdc/Y7NUf8Th/Dh4UcPQCvCtv96KesNcoHDiQSIu2VfutWnPAY0xg1wHuz1z8wHaw+8PT8zOq+ZFDUNn5tKK78anG5mZBnBqRG+27lqQe4dR5lCgr8Fib3/PzrpVJy++l8TOAmR+id0vu9L9umt/GTZt0+2Z5RpF6dOnf9TXx3aKvvkApujje0mAMDUyRV/VNQwAYfCihgEgDJVlGHHJPoDTobIMw7EFz1gfwOlRPsNwkjUMPRwhwwBOpVIBw360Y26WZhjmNsgsTOZhg4fLQACcGuUChgkG98zN0gzD3JTNLEwwsX1X4wBwapSvYThRhmFpkPAow1j7YC16lO6k5wEMK3+m56NT/RO3kt+tatiaRoEzPfNa/2g98wy4tO+qTFt/6cWl/pOGPh/vA6ddI2d6rlxfsaeFa9CwZ3qaAWlrGBo0JqMdMgO082RzZ3pq9rD8z/0gEn+sXD+5HDjtGjnTUwNESDUMe+59zKCvmQeA3Kq5liTKMCwXwEpkGAffH9jL3PUqPMdlAnnF13fZQ/z18cwinmEU+RlAk849es5edFYmW2jmkGRMNYzNzzZl9unZXF/MHB/sadKCgqtZrH1klr24TA0DQdIpILb+unU032cBzRySaAFxDOdhaGYxzm9xtwVQFR0uDfpAQHRqibvf9efGqJtfNYwTgoxmBmk0U0hjMwmTXQyej7ZPDQMox6/zME4KMhnP28OMlBqE+6jVPe/6yUwDQD6lAoarVVhRhjEIEmYQls0wkp9mxJ1UsxjKJE7gtjPq5wE4zqsaRlZN4aRg4RR9PTUMoJggahjJwZ6VSaQFhbRgoa/X5WWCGnCWeXUeRt5MAjjryo6VRj5WbaKGAaB5QdQwUB17KJagy9w9Lmu5k7Z81PoIXxA1DFQj7TwWHdya2rq7G+xZyx3bT/z/cue9pK2P06FUwGjsPAw8kLQpALLooD9R7P+XDTCx7ed6PYJDDeOMiw9s/fQoOdA1ELjMwXH9tP9fbn2cTtQwYOlAT7sQTwODZg7uECOeSST/f9nnEuvjdKGGgdTMYpT4eSzxwFBkGwgTNYwzTgd8WmaRlSFoUND1bXAw/7/iQYKs4vTzaj4MfedK++NFNfT3aw8jTDB3hxUuU9DBrzUJfd4FgbT1HX1dkfVRLf39x4N1Xs1MoDOmOT3L/hKAs6apgEENA0Bu1DAA5FYqYHAeBnA2lTskMcGA8zCAs4caBoDcqGEAyI0aBoDcvKphTE5N2i9pAZBNx4ieNNmEys70tKIgUfZMT33N1vaWHHx3MDhj0Aan6IxC+vTpix13z84/W+okrEbO9BzXnJ4AxutUzekJwG9e1TAA+K1cwDDBYCznYQDwWqmAMbbzMAB4jRoGgNy8mA/j8PtD2fx8U+4e3I2WABhFP2ptPdaShecW7OkIeTUzgU7F52FsfLohMzMz0n68HS0BMJJ5Q979cld6X/dk8eJitPBkjXysWnUNQzMLggVQgBlfM8/M1J6V+1HDKBBcADSn3MeqJhhUeh5GkeACoDHlAoYJBlWeh6EFnDSbr0zIlU/10b6szj8rq3fsYmNTrkxMyITe51fNswDq4EUNw15Yc0xPdnfnpWPrprekuzMr7cf6y1fmL4j85b5ovfbbS2sy/a8b+gSAMfOyhrH6nGYP5+XfdrblSlsfvyCr5vbCc6smXJjbzmVZer6/bvvissz/14bJOQCMm5c1jMufm+zhL5dFfvVJP4t4c17m3/5W7n9+Wdp3unJrri2Dz1Qe78hTmoEMDlcAjIu3NYzel7dk/unZ/uOvt2XWfeza7cp2PMMxJjV4FcloAJTiZQ1jZX5Czv96W7Zfm7aFzQv/aQ5TFrXAuSK9Tkfm4z/fONTgVSSjAVCKlzWMq9t7cmNuXm70tLB5Uy6b201zaHJ/+6q0H+vI7I5WMiLfdOW2zErHFkQBjJOXNQz5Zk3WZFkWNQgkaxbmUXtuVd54px8yep+uyfavFmXB9gCMk581jF5Ptp/u2CDR+/OaPHxpeShgXN2+KbOvnbeHK+ffX5a9P+Y/lx5AeV7WMOT5G3L/j/2cof36ltx8tWUfH1mQG3qIYg9TLkvyWQDj4WUNA4Cf/KxhAMin5jdbP2oYkyb4REc1APLZv7NvJ7Kqkxc1jNaPW3YyEAD5aLDY/GxTnp15NlpSj8pm3LKHJVFtQ9siM27ptH7rf163U/WN+sYn+vTp37PtVGvKBgttddzk1cwUfRXP6dn9cmvwS6GlpS3Wdp7Mn2Wcijk9e19tyd7UwshfCi0t7fH23P6mGWf1BQwvahiH+jpaWtribYFxVgWvzsOYpKWlLdYWGWcV8Oo8jFwRlZaW9qgtMs4q4MV5GLkiKS0t7fG2wDirgmc1jA1Z/+9erHXLe7L+4oRcaJv7i6vSGyynpT3jbYFxVgW/ahj6ungbLT/407L0XrkvN3vm/kpXVv7Uv7R9ZOSlpT0LbZFxVgGPahibsvLEBVm9fl4uuLb9smxLTzY/Fmk/HkXUny9J++N1+9UCIyMvLe1ZaIuMswp4VMNYkKtf35TL//6t3HRt712Zka7c/WJWpn/SX88Gpy/6M26lRlxa2rPUFhhnVfCrhhFtZ9BGwWdUn5b2TLcFxlkVvKlhHMqGvPfEC/ZQ5IVBe8UckrSl/cxt2TMpRT+ymp/zzIydNGdk5KWlPQttkXFWAW9qGJOyKP/y9Sf2UOSTQXtD5k3AmLko0vt7FFE/35DexUU7Zd/IyEtLexbaIuOsAh7VMGLbcW20vP3LNWm/PWEyjgm58HZb3vhlf4bP1IhLS3uW2gLjrAqe1TAWZMkEg0E7WN6WpY/um4zjvtz86KpM9RcPR1pa2rPYFhhnVfCmhqFyRVRaWtqjtsg4q4A3NQyVK6LS0tIetUXGWQX8qmHQ0tIWawuMsyqUmkDn2vVr0mq1+hPoxGbcsqJG/yFFZtyameO7y4Cidv+2WeuMW17VMAAUVHOG4VUNA0BBNb/ZelXDAFBQCBnGuM7DAFBQCBnG+GoYm7L6ll6H6lpnX1bnJ+y3tU/Mr9pL20fLWr/odgDPhZBh6E6Op4bhXqdttH2j99aSdH8TfVv7b7qyNBRMjstav+h2AO8VGWcV8KiGsSlXJl6QK6+dNxmAttOmvSIb0pOND0U67hPai4sy+6EuzZK1fnL50gnbAQIQQoYxnhrGgty4/4nceHvPZADafmvaG7JohvTuzlPSecyuaphMZmd3xEDPWj+53PzckdsBAhBChjG+Goa+TjOX4df3t38k2U9KX79/2HQk2QcCVGScVcCjGsamvDxxQa78Wg9JXPuyWdqW9twt6d2xa1qHc22ZjR4fl75+x7xCl3cHy83+muX9C+WBQIWQYehOjmNOz3fv35Qbb+qhiGvfNUvbsnxJpNu1q4p8ui63Ly3bGbfSpa/fNq9IXw4ELIQMY3znYejrNHMZfn3r1TXp/Db6OPS3HVl71YWLDbliC6PDstbP3g4QqALjrAoTZS4+S/v2dntYEtU2tC3y7e3dr7Zk5mdcfAYUtbsTwLe3aybBtSSAB2rOMDyqYQAorOY3W89qGAAKCSHDGN95GAAKCSHD0J2khgF4IIQMQ3eSGgbggRAyjKEahuEyC2U/UtUMowBqGEBJIWQYLpNw4v3B4UmRoEGGAZQTQoZhdzI2yOMZhnJBI7fBP3pDVt/R60e1jU9v0xua+ObkK0yz1s/aPhCoEDIMu5PRINdaxrGMo0iwMI5qGG472kY1EmP/neWhiW+WTxjs2eunbx8IVmzc1aF8DSMa5PppyVANw9zK1TCyrlbdl7X3hye+eer9tRFZRtb6WdsHAhZChjGeGkbW1aq3pbczK+3YxDeTOz1xF50el7V+1vaBgIWQYdidjEW26moYbjvaHs3p2d/ekWQ/KXv99O0DwYqNuzp4VMPImtOzLTNzt2MT35jBPzczYh6LrPWztg8ELIQMYzw1jKw5Pduy+FJ84psNufWSLs2StX7W9oGAhZBhjKeGoXQ7+unF8Pbbr68PTXyz/roLF5o1XDlWuMxeP337QLBq/jueKDWBzvUVmWodTaCj15NMTppBqNzgN/Ei9wQ6fHs7UEoQ395ug0IU2ao9DwNAITVnGB7VMAAUVvObrWc1DACFhJBh2J2MDfLqzsMAUEgIGYbdyWiQU8MAGhRChkENA/BECBkGNQzAEyFkGHYnY4OcGgbQkBAyDLuT0SCvtoaxKatv6YXrrj1J1vpZy/eHJtZhCh0EL4QMY3w1DN3O8e9WzZa1vuu75/t6by0NTayzlCsoAR7LNU6q41ENQ79Y2V1F6q4qPX6dyJH09TfMK9KvSu3JxofxiXUWZfZDXQoELIQMw+5kLLJVU8NYjK4m1atI3VWlN0ZMcJO+/mLmVak92d15SjqDiXVMUNvZJWAgbCFkGHYno8hWx5ye2bLWd333fF8/8zmS7APBif1918GjGkbROTez1s9a3pb23C3pDSbWMT93ri2z0WMgSCFkGOOpYYyaczNt3ous9bOWt2X5UnxinXW5fWlZWlEXCFIIGYbdyVhkq6aGodx2tI3PuWn6c52UWbZGrJ/y6Unr1bWhiXXWXiVcIHCxv+86TJSaQOd3KzI1NSXTrWk7Ice5h8/1n9CdN3ebYRwe5p5Ap/fVlnR+llXe1C8lWhb5YEsux2YCByCyu7NpxpnnE+iMp4aRpS2XtwkWQKqaMwyPahgAChv5Zls9z2oYAAoJIcOwOxkNcubDABoUQoZRbw0DQKYQMgxqGIAnQsgw7E7GBjk1DKAhIWQYdiejQU4NA2hQCBnG+GoYG7L6jk5ro22e60iz1nd997yjJ4EdTaBz8k/IWr/odoAxCSHDGF8NQ7dT5LtPs9Z3ffd83/47y0MT6CwPBZPjstYvuh1gbHKNk+p4VMMY99Wq+7L2fnwCnSV56v21EdlB1vq91OWEDDQihAzD7mQU2aqrYYy6WjVN0atVb0tvZ1basVPMJ3d64i5ePS5r/a5dfjQRjwmOZvntqAfUKoQMY3w1DN1O2hydWbLWd333fF8/8zmS7Celr5/89xX/9wKVyTVOquNRDWPcc3q2ZWbutnQHE+iY/ZybSblk3slaP7nc/PtHbgcYoxAyDLuTschWTQ1j1JyeGhx00McVndOzLYsvxSfQ2ZBbL+nSLFnrJ5evn7AdYIxCyDDsTkaRrZ45PU1/rpMynd6I9VM+PWm/vj40gc76626Yp83olb1+9naAmsX+vuswUWYCnWvXr0mr1ZLpR6fl3CPnRH5khuakGZyGBg97OGL+yzuBTvfLLZPmZ5U392VlfkkmmUAHOGb3b5vSedLzCXTGU8PI0pKrTKADpKs5w/CohgGgsJFvttXzrIYBoJAQMozxnYcBoJAQMox6axgAMoWQYdidjA1yahhAQ0LIMOxORoOcGgbQoBAyDGoYgCdCyDCoYQCeCCHDsDsZG+TUMICGhJBh2J2MBjk1DKBBIWQY1DAAT4SQYVDDADwRQoZhdzI2yKlhAA0JIcOwOxkNcmoYQINCyDCoYQCeCCHDoIYBeCKEDMPuZGyQU8MAGhJChmF3Mhrk1DCABoWQYVDDADwRQoZBDQPwRAgZht3J2CCnhgE0JIQMw+5kNMipYQANCiHDoIYBeCKEDIMaBuCJEDIMu5OxQU4NA2hICBmG3clokFPDABoUQoZBDQPwRAgZBjUMwBMhZBh2J2ODnBoG0JAQMgy7k9Egp4YBNCiEDIMaBuCJEDIMahiAJ0LIMOxOxgY5NQygISFkGHYno0FODQNoUAgZBjUMwBMhZBjUMABPhJBh2J2MDXJqGEBDQsgw7E5Gg5waBtCgEDIMahiAJ2p+s524b0SPAWCkcockAM4kAgaA3AgYAHIjYADIjYABIDcCBoDcCBgAciNgAMiNgAEgNwIGgNwIGAByI2AAyI2AASA3AgaA3AgYAHIjYADIjYABICeR/wcuChc1qIFnTAAAAABJRU5ErkJggg== data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfcAAAC+CAYAAAAoVUY3AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAA6mSURBVHhe7d1BryRXdQDgbo9HshWDYRPPyMnCskDYkmUx8goJL0zIYrKNEuUnRJFYZRkioih/ANbAjyAZRRjMJgoL0IzCKCCUBQsHZuRFTCSLjOSBSd+aW0W9elWvq7pvdVef/j6pp+vcun2rbnV1nzrd781bP9lYAQBhPJPvAYAgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyB4BgJHcACEZyL+Rvf/CoukUVfX5j3Xn3Xl46TxHn/96ZP6fnPv+oJPdCnrueF4KKPr+xnsv35+rc5w+nQnIv5NHHsd/4os9vrHP/7MJnN3AaJPdCnrv+XOg3vujzG0vlHo8LNiKS3At59HHsl0j0+Y0lEcTjgo2IJPdCfOd+HiQC4BRI7oX4zv08qNyBUyC5F+I79/Ogco/HBRsRSe6F+M79PEgE8bhgIyLJvRDfuZ8HiQA4BZJ7Ib5zPw8qd+AUrJ9s5GX28Hf/lhLgo6rCrRJh+o46WPzO/91bvfPlz+cZn5/1ep2Xztf3v3s33DmQ/kvd22d8Xp/7/KOS3AekEz5VqqlSGXN/59nXNv8+VbfXosS3H/+suq/jc7v/sz+9tfmXlODHHC/37t1Pvy91oSW5D3j48OFq9XhzwJ/dVLCPN4f82U3jlvju/QerL7zxyuj+pxZHn9+2+ObNm5vG1erfq38veuXBg+LbW1pcz//B+5u5FhhvKfHd+79YPd9z4fbKZp4lxl96nOb/+hub57bQeOL94k/d+NQm2J/kPuDhf2+S+0Q//dmD1euvPX0DjCj6/La5+cf9yT0lgXNQz79K7oGk87qb3M/lOU3O/XW9NDf+6EZe2o8fqBuQrqAq6YpqQyzuU1XsG8XGX3qcFRtvAfGmbrqgrtgrBcZPlhyn+ZccLxHvF5egch+gcr9M5X6xcj+n6i45h8r93J7TROW+LCr3ue1wxRX9CtgV/u+dXcWe40ah8RYTb5xbxZ6IFxoXoHIfoHK/TOUes3IdK3Llfs7ntcp9WVTuMyt2BSauhImzYuOdWpwVG28B8bl/IuUTueXFJajcB6jcL1O5x6xcx1K5x6RyXxaV+9x2uOLynXv8uFFovFOLG4XGE4sr4koTF6ByH6Byv0zlHrNyHUvlHpPKfVlU7jMrdgXWE6c3ye761Fbfkm2P797q9e22ypbxu+1920uG4u543e2NGa/u2+3fbr/q8cnB4izF3f1N2vvct/7k46zYeDm+cMw26vXteK7j2f1E6sK+dPq396eypf9Vcbd/e5wxj68UiNP86+2muL0f9S3178ZJWk7acfeWXPX47i0Z6t/dv/Z82u3t/knVNxnRv93e7l85UFyCyn3AXJV7dcJstKuf1HZV3DW0fmicqe1DuvNL/ZPuY9rjbBtzaB+G2o8p7UNS71+9PGQJ+1zSmDnvonuc6njovrT2eT20L/VyMrQ+GbuP3bF2HaeEev7tbdbL7f1sLyfdOGmP0dZtr+N9+29rr5eTofXJmHEOReU+tx2uuMZ8J/3hgw+fLowYL1lS3J3fhZM+929eDDneNt9GN86a/tlV+5fMHdcebPk99/o4TB1/6XGj0Hhj40Mdz0ZP3He+Nwbiwe1ldXzpfMoGHz9TnI5zr7y+sYnHHI9m/KwbN3bs39X3+PZ+7jx+d//mjguQ3Ic8fnpX/af+yYg4PS1T+icprk6+HH/65qcvxEOPT3/EI70QU//Klv4l4r75NTpxvX/bxm9s4r43ltS/3b5tvLnjxrb+2dTxlx43Co03Nk6viTHn075xkwg2cdpeO75gZP++7bX7dden1/NV6+eOB3XXXxGn/b/0+s+6cTK1f2Vgf7c9fsr4aX8aeXtN/7njAiT3AcWuwCbE6WTaVhHWcaqI0xtA6p8eN2b8Suk4a8dpf+r9q18gQ4+v97+ae/3GuJEe39e+9/7uG2dX9U/7fMqf0CSDcVZsvCvi9vlTnwd1XGL8yiZOb6fd9c151+2fje7fiet+Q+vT66E9z23jlYjb869fj231/lTzy5rHZ+049eu+/ht5+21T+yfd7Te6/SfGQ+9H7eOVzB2XILkPKHYFNjIeW7GnOPWbOv5scdaOL+xfdtV4qX/7hZSk9X3tk/evdJwVG+/U4qzYeFviS89/Vmr8FKe31XZ84Y292z8b3b/n8al//Ylb/Wd0u/0b28YrEHfnP0bTP6vj+jh01zc640/tXxvdf4c47VPzfGbN9nL/ueMSJPchO1xxpadnSv8kxdWbw+aKsY4rW/pPGb9SIO6bX2Nk3H18NZdkE6fluuKt21P/qcenMlPcKDTeqcWNQuNti6vnvvNGWyk0/uD2BtY3RvbvxnWFWp/Pfed727bx5oh7j3dX7t/IcT2PS+uzZnvZ1P6Nkf2nxu39Scv181Nvr+k/d1yAn5YfMPdPyyf1i6jdVmuv63ux9Y2TlGrvM/TT8snYbfVto+7fXTfUfizt/RmaYzI0z1M35/MxdDzbx3Ku49r9afmu9vZrfW21Mfu7bayhx80hzf9Lrb9nn7bd3Zd6LnV7X59alPZ22yGV+ml5yX3Arx/++ulHJemK6vHTK6pt8d37v1i9/sbmxBjZ/9Ti6PPbFtcfpaYXfYnxTi2OOv+79x+svvDGK8XGO7X43Oe/tPjGDcl9Vv6Husuiz2+bY1/RH1vU+Z/7eX3u818av+c+t3RFtZGuqCoj4s1116T+ySnF0eeXbIsbBca7/tP/XP3Bz/+riZN9xkvmjhuFxhOLK+JKExegch+gcr9M5V62cn3xH7+2Wm1efv/79/+QW5ZN5R6Tyn1ZVO4zK3YFJq6EibN9x0sV+/X7P6lu1z74YO/xDhZnxcZbQHzun0j5RG55cQkq9wEq98tU7uUq11S1X//Jf1TLj975k9VHf/031fKSqdxjUrkvi8p9bjtccfnOPX7c2GO89F17qthrz733vdW1//ng6fIO41UOFDcKjScWV8SVJi5A5T5A5X6Zyr1M5dqu2munUL2r3GNSuS+Lyn1mxa7AxJUwcbbr46///GLVXkvV+/qjjyaPd/A4KzbeAmLfuZcdLxHvF5egch+gcr9M5b5/5dpXtdd+85d/tfrNn/9FjpZH5R6Tyn1ZVO5z2+GKy3fu8ePGDo/vftfe9fw/f2f1/KPHT4Mdxk/mjhuFxhOLK+JKExegch+gcr9M5b7f3P/1tddWX3rxxRz1+9r776/+6Ze/zNHy/Mt3765uBTsHVO4q9yUpVblL7gPee/deXsoV69PFivg84/Yf15jq7U9+cvXuJrk/s17nln4fPn68+sMf/zhHy/P9TXIvdTxrYrH499758ufz0n4k94LSBUGpJ2aJos9vjDubY3B7h2Pw2698ZfXkRz/K0dWuffWrq/Xt2zlall3nv2Tnfl57XcfkO/eC0hVYZNHnN0b7CnusJ/furZ5MqMZ/+81v5qXl2WX+wOFJ7gVFf+Pzxr7bBc7vvv3t6v+QH+1Xv1o9uXMnB8viAg9Og+QOE0y9wJlatdeWWr1HvMA79wsWF2wxSe5Hsl6vL93G6vYdGmNq+1RD47Tbu+v6bOs7ZoxDqd8Ih/a52z65aq+l6n1zYbA0cyWC7nGrtePuulL6Llj69qN7q/W1XaWvf7utu25uaf7tbbb3Yai91l5O2n3qW21b21Xr2qa2J0Ntff2H2k+N5F7Q1De+9LOM7dsYfSdie4x6/dT2Mdrzu2qcdvs22/Znyv4dQv1G2LfPfe3Xvv711bM//GFzW12/XvUd43ff+lZeWo45Kvdtx7OOD2Voe+19TLdkaN+HXNW/3Z5uh9TeXr08tA91e6nj1G5Pt2So/9T2pL1c22WcUyO5FxTxI8u2qfOrXyiRzPoR5gsvXLgQuPaNb+QVyzHr/K9wyHMp2jk7xZRkdirH6VyfT78KBwf0+O23V6uPP87RReu33lpkQgdOj8odFmL9mc/kJYD9SO6wFJ/4RF4A2I/kDge0fvPNvHTZVesAppDcYSHWN/3xDqAMyR2WQnIHCpHcYQHST8oDlCK5wxK88EJeANif5A4LsP7sZ/MSwP4kd1iA9auv5iWA/UnusADrGzfyEsD+JHdYAh/LAwVJ7nBIfb/u5lfggMIkdzigvv+oZv3yy3kJoAzJHY5sfetWXgIoQ3KHI1u/9FJeAihDcodj85PyQGGSOxyZv+MOlCa5wzGl/3bW33EHCpPc4YjWn/tcXgIoR3KHI/KRPDAHyR2OyUfywAwkdzig9Ztv5qWnujFACZI7HFHf/1gHsC/JHY5JcgdmILnDkazfeisvAZQlucOxpN9xB5iB5A5HsvY33IGZSO5wJOtXX81LAGVJ7nAka38wBpiJ5A7H4mN5YCaSOxxQ9Xvtz2xedn4FDpiR5A6HlJL6tWur9csv5waA8iR3OIL1rVt5CaA8yR2OYP3SS3kJoDzJHY7BT8oDM1o/2cjLwAE8uXNntf7iF/25V2A2kjsABONjeQAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgGAkdwAIRnIHgFBWq/8Hmd35bOEEShwAAAAASUVORK5CYII= 但现在的问题是,在后面的单元格,我是用的 A2*A3 的做法。 但是它不是按17来算,还是按原来的值来算,SQL的语句不能碰了,所以想在FR上想办法像下图 要如何才能按17来算? 12.5 * 17 = 212.5 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgUAAADWCAYAAABBqfGlAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAABlvSURBVHhe7d1trBzVecDxs/deFxu7ji2VBkObxBEGQotUO6DUqAHiiigY9UMgQfQLFrLVDyCSkESAqCGIFykUhUCwaSNhB1yp5aWCSNSkSlRHQlVRRLClEEIDbUxVxL0FlBDA2Cq+vp3n2XP2njue2Zmzd2Z39sz/J61nnzNnZ86ZOzv7zNnZcWcuYQAAQOtN2CkAAGg5kgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAqrVJwb4fHbDPyul0Or2HLx07/epXUV4k3b+85YSU+2VZ87Jk1RV55VV62m6DvHWFlPtl6XlN5fpftbxt4Md1bZ8q9uss/ernvWYUpP/ptmbFbpp+7mInlnJUp7VJwRE7LWtubq738KVjp1/9KsqLpPuXt5yQcr8sa16WrLoir7xKS+00b10h5X5Zel5Tuf5XLW8b+PGwtk+/tuSVZ+lXP+81o5Jua1bspunnLnZiKUd1WpsU1HXAbIrY+1dGaOIXm7b3H0A4rilAtNqeGMXYfxI9oF4kBYgWHyDxIdED6sU1BZHijIIDKB8gAEJxTUGk+EAgMSIxBBCKrw8QLUYK4kOiB9SLpADR4gMkPiR6QL24piBSnFFwAOUDBEAorimIFB8IJEYkhgBC8fUBosVIQXxI9IB6deZaeo9IuYf4povW2yg+sfevyLOvHjGHjxqzbMq0errptLhSg7bv123vP+oXRVIgbxTJoP3DH3G7Y7PuE2ZZMjmcPFo9feWl5N/qty8xMfG8KuNRJ31RJAUzr83YZ+X94qVpc9Yn1tgoPrH3r8jBo6v0TPnZF6bLf4BGNL1k/Rrt/1lL306ieLR9v257/9vg5D842T4bjSiSgrdn3jZHjia51lQSJAfCpVNLC+P9Lxw0Z52dvLlK1h+3OPb+FcX7jyzVD8h9B6bN1o2rk2ftseu5I2bj2au0/2un3q5kezYl3p8keeedvbay5Y1b3Pb+tyEmKagAIwXHY6RgfqTgaxcl28G+4UzyBjTeGzDG+I4fHGSkIFKMFMRv1ElBHL8+kANiQjIuVSJODqNB9cU4xbH3T/SLdSjdlS/tlrdlqhcZ2qnK2D6CmFgRq8bEI8ZIQaQYKfBGCi5em7zhkkQpOaOWN96RpDzmePtTjBTEipGC+DFSUAE5EKrkwCiIiReOFLhp90ns8bKpZQv7X8H2VA2I2z4C1vb+i9jjUWOkIFKMFMyPFPz1X6ztvuGSuA3T7U8yUhArRgrix0hBFeSAmAjJyLimIO446zv1tky5pqA7ISZW4xaPGCMFkWKkwBsp+PxaW9oOjBTEi5GC+PGTxApwn4LjY+5TMH+fAj8p2HB/Mj+ZJrWHOv33a5N/huTOp2a4T0GkMfcpiD8mKahAnSMFa/5wjZn+n2kbdUmZk56X5td13GvylhNaniWrf/L6rNe55RYtU1TRtmHIGyk4L0kK5Gr9+TfkcOL91yXxkNQ9UtBvH3Cx/7xK6f26336X1YZ+9ftJL2vQ5SyW9P/PP7tBn8t6/XY46XLXvn59cPy6TlaZ06++CC0XMi+rzCm7nHHFNQVVkANwQjIuVSJO8rLC+r0dzpuvO+z0tO6Av5n+TbdOzutd7NfXHTeZL69zscyXuN/y8+qrjPWn+6fLcbz6/vp6dTKWJ7SuXb9f35W79rnyfu0TdcYLvlP3dLdL8iGdnLnrB7aNhUzljN59gGfN92Opl1VfYlm+TP36TqfTsc8WyisPVec1Bfq37rN/utjVVzXF2paM/VHm956LEvVF3vpcPT92/feXU9TeqmJpv5BY1i/cVNn6QsuTuNdXkZrv/z1FXv9ESH1Xnt7eefWlP+65cP3Nq+/KQ/+ejY9HLI6kQM7MEjoEI0rEsvmL6suOpkosTzQpTvev1xdh669es7pbbuOi/vakY6tX3+rXPlFnrP8HgC1Pc0P5ekZvp7K9pFy+Xtjw7e6Henq+H8t8qZeu78plRCK9HFF3QiCk3wv6b6dVbl+RF69Z0z1YV7W8vLgnI87a33ty4tz1WS52y86bX7i8imJ5/2ay83uSuMz26C3fSsc9A9ZPy3q9386Bl59u37jFI8Z9ChIhsey0LnaZatHrpZ57iKL6tcVWOu61LeD1ri8LJPUXlBctr8Y4b6RAyAe28EcAJCHwy/XaA2++vF39uGiaVX9YRn2fAjmjK7U/DRB3t2s39s+YZX1+7CtdP2N9Us+dEafny7x+8+uI/f7nSc/vF7s+yMOtrycdJ0Lri9z2Fr0+YPnaHqu3Plt/3OJRiyIpqCxDC4hlJzzujCGnvtRzD3ldmeWrqmPLj10/tG3JGZ7Ie71rf2+EwXLl7gyxZ7HtXUScN1Igbz//jD8dy5m9P5JQVF/irJEHkS6X0YCsS3jyygd1+OjhBf2vYnuqPrG//7j9o2h/GiTubv+F89MjXr35Vun6qbhoxEPmyaN3xl6wvCpiv/+ybnnf+Vx7ZOr0Xm/5seuDLsv+vXrs+n2h9UV6/T3p+oGxtiHjeORvLzFu8ahxTYGNRdnYfZCWqa87a+Dyq4iz+tfjxX77ejKWJySW+u4MqyeZL+W9MyarX/tEnXHRNQUifUYv1wDICIGMGEhykJ7vx1LPXVOQHmFw1xT45cNKCESd1xSonDj99++paPlZsb4Xc874e0rWz3q91JeHe67S9a2i5dUWF7H1e2ycHuFISy8/tH5PyfqDxHnHI9GrP27xiHFNgY1FmVgPKvJBamNVUD9k+aqCOKt/PSXj9Ov9MyJ/O/hnhKHbR9UQ97umIH1G76ZyDYDImt/dngtjd01Bur67piBdLgmAPNxzJ698UKO6piB9xtZT0fJz15czv6dk/XQsdd3DxeK4ERCraHl1xK5Nfdn6PTb2389ZeuuzQuv3lKwfGvvt8Y87bn29+uMWjxjXFCTyYv1A96ZuvsT+I13fX57sqH5diWV+Vvkg9YW/PpEVy2uETN18ybAXLNM7g9L6qeX59f31yxmEX561fjXEuN81Bf6Zf9mpvF39WEYIXOxGGCT2Rxj8chkNcA/hT7PKF6POawqy9sPefMvtD2XPyEPi7t/Bxgm/LfIQMt89l2np+jnrd/Xc1N/f5ZE+g06/vspY+p9uj/Cf+6RcXu+/xi0v7/2f17+660v/JBY6tf0vs/zQ46FqaDxq3KcgUrH3r0i/+xS47/pF74w+eUPKB7ojH+aSwbsEwI/T9XWEQd7QXn0h5a6+JAjCHwnw33p55YPgjobxanv/24D7FFRBDsiJkIxswRnHAK8XTY5j75/oF/tnyjMzM5o46p0vkw0jH9Zn3d2dSixc+Yaccj92U1ffxW4q5bJ8Fwu3fjmjkTMcmUos5dI+ieUMSKZ+e938kHhU1xQQEytiNXA8YowURIqRgvmRgq3nyjfsXZv/8eRuwpQ8hjnd95fh++igdjx3mJGCSDFSED9uc1wBOUPSizQk49Ih3OJ7TfN/H8Qd+//3wTUbV1e+/CbHuw4Y/u+DSGP+74P4Y5KCCjBScDxGCrJHCtqAkYJ4MVIQP64pqIJkWAnJuFSJOMnLguqLcYpj75/oF7f5O3WuKehOiInVuMUjxkhBpBgpKB4pmHjjDbP8od3m3etvtCVxYKSgGitvvdnMfvRj5siFnzGzaz9uS0eLkYL4MVJQgcoytD6xfIBM/cfPzbLHHjErH9hpVn5ju1n+dzt681WF61PEapC46Hf6J+x9yqy6/qtm4q03Sy1PjUk86v/7oM54mCNgRz++1ix7+p/N6uu/ZlZd/Vdm+cO7zOTBX1W2/EHito8AitjjUWOkIGXqxZ+bzqH3zNSrr+pj4o3/NUv++1U7d96xE080b//NPebYhz9sS5qFkYLskQI5qK/4251mSTIV//fHZ5t3vnGbPo8FIwXVmPzVf5nVN3zdRvOOnnSS+eDcT41kBIGRgvgxUlCF0Izs8Ltm6cGXzYof/Ev3zP/W7Xom8Htf/LxZdevN5kN332WWP/6oOeG5n2QmBOLQ5VeY3zn1o90gdP1DiLmmIPWd+rvvmpV79uhZn0sIxOxJvz/Q8kVTY64p6E4WGy85/Y80AUibevPNxo0gCOJI4hFr5UjBCT/eZ373AblF3WA++Nha89u777FRMzFSMD9S8JFXfmou/tc9ZtU7b9m58575sy+Yfedd2v2/ApJHLFNGCqpx4kO7zYl7n7JRf8MYQWCkIH78JLECg9yn4LWH/8Gc+f2/l5cHe/9bO8z7Hzk1aH3DjrlPwVLzoTdnzCl7dpqTfvpvyYxsB794lXnr0itLfdCO45T7FCwunnw5+yuEIpogfCpJEM7/jFmy7qzK2sN9CuKPSQoq8PSPDpS+s5w/Xb3/WXN2YGLw2sZN5hcXf6HU8pmObnrGf75oTvmnh82S999Lonwvbb/HvHnG+u6Qe/KGjG1qDr5UansxzZ+e863t5sTf/jp5Fm76T/7UvJAknWXWw5SpTDddtD75d3SiSAoGIYnEZ3+y15i9yaOkuZNPNlMPP2w6K1fakuaS/m0e8c41CnMvv2yO3nmn6STTMiZ27DATn/ykjeKyL9kHRn2Aqdoo+jR7331m7pFHbBRg82YzdfPNNqhGjH9TNEscFxoGmnvnHXPu7m8HJQRi8rrrxiIhEJJxton8TeXgPbtlS+mEQHTWrbPP4iNnHli8ic99zj4LUENCAAxD65ICPZO89lqz+tVXbElJF1xgJs4/3wZokmPPPGOOJsnAIGdz45LkDSLGxHAUiU7njDN0lDDExIYN9lm1SPRQt1YlBZoQXHNN0JmkmFu+3Ex+6Us2QuOsWGE6a8KvyJa/a8xi/AAZVaIzceGF9lk5s/feq8ebqrVtBBDD15qk4Njevd2h5ff6X3iW5asvvmgmTj3VdDqd3qOsdN28ZYSWF0l/IOQtxy9Pz8tSVLfMMqomZ2VTDzxgJnbuNGZ9+e9bf/z66337Mu7q+gBx2yy93fx4mNs0qx3ph5NV1o+re85NN9mScuQ4I9e2yNdaVfPb7577j3S54z8Xfh33cIrK+s3zhZaLvLKs+nnlGFwrkgL5rvnYHXfYKMzcunVmx8yMkesx/UcZWTuwvww3P7S8DP8Dod9y/PIiRe0JaV8dJDmY2LbNRsU2bdqU25cY1DFSkLcPuPJhb8e89fltlIfIa3sev/6BQ4fMwSNhW1RGJGe/8x0bVUfa47jnfpnPlVe1nfxyeYi8+qHlwn/uDLIcDC7qpECy9KM33DDYlcPW1Pbt9lnc3Bts3B3bvds+K9ap6XvfphjVUHOd+1L6Y3mY++z3fz3AzxL37tVRyqr4/Q/5EByX93YMx6BxF21SMDc9rRcUmmeesSUF1q/vDj9fcIEtSN50V1xhOqef3n2evAHdo4w6D4yh/HZU1a70dmhCf4/t32/M88/bqNgtt9yi7W7S36pKdYwUlCHbMr1/VKVsouP+rotph+uHe3z9hz+0c8JUeX1B1Yme378yQusPS9PaM86iTAr0gsIrryx1QaFcVTyxfXv3O+nkzHHyppv0AjQtv+oqW6t7gHCPoh1Q5ku9Ucr6QMhrV9n2ur6n6zehv2I28Cui27/7XW2361dshjlS4G9Dtz+Mcpu6v+ti2uH64R4TZ5658FcImzfrsaNIXdcXZPXNlcm0DNe3rGVlCa1fJ9eGkP6iWHRJgQzV6S8MCi4o/OCEpfqGXvLkk2bikktsafIGXrnSTCZnkP49CQbZ4dzO6p4PW/oDoao3jiwjazmj7q/83TvT0zbKYA/gC35xEPgzs3Ez7JGCphyY62xH71cI9j4Ecuw452c/K/zJYl3XFyxG6HZqyt/XJ21qYrvGWVR3NJx98EEzt2uXjbLJh8LEFVeYicsvj/o36m3zwaWX5icF8usE+WoooaNId9xhOq+8YiYfekh/gw6UNffLX5rZxx477sZEevOsG2805sABW5JNElP/JARomiiSAn1DShZecEFPZ+tWkoEIyShB3q9L5AwufWtq3V/uu487zqFyRScmcytWaILqrlUCmmbskwL9hcG11/a/fmDzZjO5bdtAN7hB8+WNEsiokFwrwgEYwyR32Jy97TbTOXTIliw0l+yPU/ffz8kJGmmsrynQoeDLLstPCNavN5NPPKFnhCQEcep3LYFcG0JCgGGT26FLMir3OMnSxOsLAGdsRwo0G7/9dpN5QaH8vHDbttruP45m0FEiSQoz9oFO8vef3LrVRsDwua+pzNNP25KFuL4ATTSWScHso4+auXvvtdE8+f54Uq4IJhlohdldu8zcgw/ayMP/UIcGmX3kETMnyUEK1xegicYuKZArx9MXFGoyICMDZN2tkTdKIEO2Uzt28H0tGkW/6rz66uOuM+D6AjTN2FxTIB8CH2zZsiAhkAvJ5BcF6XsNIH7HHn/8+IRALiz85jc5wKJxZDRg6oknjrvOgOsL0DRjMVKgWfYNN5jOzEw35l4DrZY3SjApPz1kKBYNp7c9fvRRG3VxfQGaovEjBXI/e71DoU0I9PviJOPWnxiSELRS1iiBHFRJCDAOJr/ylePurlnl/48ALEajRwoW3JSGew0gMff66+boli0LkwIuLMQY8u+uqTHXF6ABmn9Ngf3fC7nXAMTs9763MCGQWxiTEGAM6XUGO3YY8+lPd2OuL0ADjO19CtA+Mkowe9llNkrijFsYA+PIvz0y1xdglKL7XxIRLxklcPSXBnfdRUKAKOhPqnfu1P2a6wswSowUYCykRwkmkoRAbicLxGRuelp/aWU6Ha4vwEgwUoCx4I8SyC2MSQgQI7luasmePaZz2mlcX4CRYKQAjSdDqbNy4yrBLw0AoDaMFKDx3BmT3A1u8stf1ucAgOqRFKDR5OZV5vnnuYUxAAwBSQEa7dju3TqV/5++c8op+hwAUA+uKUCjyV0tBb/bBoD6kRQAAADF1wcAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFAAAAEVSAAAAFEkBAABQJAUAAECRFDTE0Y0b9QEAwKh05hL2eRTcB+vUs8/q1Jf3oZtVt5+iD+8yy5Nl+PWy2p2uU0bWcrJk9SFkXenX93ttSN20sv0RIXXrlLVtxWL7sJjlFslbb53rBNA8rRkpyDu4iX7z6iTrzVp3XnlVFrPsfm1OC6mbpWw9EVK3Tv3asZg21rVckff6OtcJoJmiGCnIOkBlnfEUnX2VPftxr6nibCnv4Bqy7DL9dwbpry+v71nlIXXT/HaKqurWTdqStX6/jXnbw5dVJ3S5ZaTX7S+jrnUCaK7WjBTkHbxGfVCT9fttSMdVcgfzQdfhvz6PqxNSN63Ma52QusOQ147Ftq+O5RZtu7r6AqC5okgK5CDlHuNEDsru4WSVFWlC/0PW3a+u63eZ5YXUbTJpv3sMSyzbDkC1+PXBiPgHZf/A7MchiUGRcfgQCGkjH2qDW+y2Y9sD8SIpWAQ5OPqPEHJA7XdQLZq/GOl2h7a9Dq4NZfocUreIvw2KHjFw/QjdduntUNe+CWC0Wp8UVHmQc8tqsrw2hrQ9q27IctNlLh52QjBMdbW7DdsOwPC06j4FaVUeJN2yxCgPunl96te+kLb7dfO4ZZStW6beIIr6Miyuf2XaU1ddEbKd+y0zdL0AxkdrRwpCDpBljMsBMqudIW3Pqxuy3JD1jbuq9zOnruWW4f5+o2wDgHq0cqTAP5hV+QFVZt11y2tDUduqaHvIMsrWrWOZPveaMkK3jb/ssq8t04dBllskdNuF1gcwHlo3UlDHARVhHxJt+ECpaz9j/wVQp1YlBRxQF24DdPeDso+ySAgAjKvWJAXugBpygJfXpD9E07HjL7+J+rUrr+1Z/U/z6xT1PaTuuPL7V2UfB1muv70Hkfdavy0A4hLt/33gk4NX2YOjf6DLOviVWdewhbSpX91020P6n9XvkLp5stqQJ6RuXfL6nFZmmzpSdzHLHXTblWkXgLi0/j4FofIOhFI+DgfJrDYutu0hrx2HbYSuvL/VYvcXAM0V3a8PAADAYBgpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAAiqQAAAAokgIAAKBICgAAgCIpAAAACWP+HyltRIlT/q5jAAAAAElFTkSuQmCC
  • SQL查询语句为: select MAX(123) from s14 WHERE 12= '22' AND ks= '69' AND xt='01' 想转换成直接在单元格写多条件SQL公式,但是一直弄不好,麻烦帮看下。 =sql("test", "select MAX(123) from s14 WHERE 12 = '" + D18 + "' AND ks = ' ${ks} ' AND xt= '${xt} ' ", 1, 1) 用上面的公式不行。
  • 做了一个数据集取数的SQL语句, 在页面打开时就己经运行了。 但是因为页面中的动态传参,或是其他单元格之间的刷新动作,导致多次执行,、、 能否做到SQL只是执行一次,不管页面怎样变货,除非是F5刷新页面,不然不会再次执行?
  • 我想在填报过程中不要执行,一直到用户点 提交 的时候,在真正插入数据库之前,执行下面这段代码。 同时下面的代码会返回一个值,比如:234。怎样做才能定义一个参数获取到下面的值234. 同时这个参数我可以定义好多个单元格。达到单元格获取到234. SET NOCOUNT ON UPDATE 123 SET dd = dd + 1 FROM 123 WHERE 234 = 234 AND 333 = 333 SELECT RIGHT('0' + LTRIM(CONVERT(VARCHAR(4), GETDATE(), 112)), 2) + RIGHT('00' + CAST(MONTH(GETDATE()) AS VARCHAR(4)), 2) + RIGHT('000000000' + CAST(cgxydd - 1 AS VARCHAR(8)), 8) FROM 543 WHERE 234 = 234 AND 333 = 333 SET NOCOUNT OFF
  • 像下图,是己经显示出来的报表,但是我是做为填报依据的,因为有的时候内容太长,需要拖动拉大一些查看, 想把框中的那个分界线向右拖动,可以吗? 44210
  • 本帖最后由 afr751116 于 2016-9-11 16:58 编辑 下图,第一个是下拉框控件填空,数据的由来是一个SQL公式,当然用户也可以自己编缉。44371 我想做到就是当用户编缉完成后,及时验证编缉的信息是不是跟SQL的结果相符,比如 01不存在SQL结果中,编缉的信息清除掉。 让用户重新编辑。该怎样做? 另外就是当第一个单元格的信息编辑好以后,后面几个单元格数据列的信息会因为第一个出来了而接着出来吗? 例如第一个是代码,第二个是名称,当你第一个没出来,后面三个出没有出来,第一个填好后,后面三个就跟着出来。
  • 本帖最后由 afr751116 于 2016-9-11 22:58 编辑 在论坛中我找到了,执行全屏的JS代码。 但是有 把参数面板往上缩 跟 左边的目录往左缩 的代码吗? 原因: 因为这些全部缩了才是真正的全屏环境下。。。。。。。。
  • 本帖最后由 afr751116 于 2016-9-11 22:11 编辑 在填报环境中,如何做到,单击该行时,能获取到该行指定单元格的值? 例如有1行,不管点击哪列,只要点击这一行,就会获取到 A1的值。获取该值为参数值。

338

270

338

10

个人成就
内容被浏览67,226
加入社区11年120天
返回顶部