请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
tudou(uid:29902)
职业资格认证:FCA-业务分析理论 | FCA-FineReport
  • 报表填报属性中关键字段与单元格匹配为包含关系,如何设置?,如下图: 43202 单元格F2的值包含在field002中,比如:field002的值为:06840646、06840647,F2的值为:06840647,如何设置,让F2的值包含在field002中,就满足更新条件而更新其他字段值?
  • 表A,姓名、日期、费用名称、金额,id 表B,审批人,workflowid A.id=B.workflowid,表A的1条记录,可能对应表B中多条记录,我现在要做报表: 姓名、日期、费用名称、金额(按日期合计)、审批人 如果select a.姓名、a.日期、a.费用名称、a.金额、b.审批人 from A,B where A.id=B.workflowid,就会重复统计费用 如果ds1:select id,姓名、日期、费用名称、金额 from A,ds2:select workflowid,审批人 from B,通过过滤关联,报表就会很慢 请问各位如何解决这个问题?
  • 如图,我实习生月报表统计,人事只需要姓名、合计天数、金额即可,其他不需要,我如何处理? 天数是根据当天的累计工时来判断是半天还是整天 40118
  • 本地环境为WIN8.1+IE11+FineReprot7.1,预览效果为:36557 服务器环境为WINDOWS2012 R2+JBoss-4.2.3.GA+IE11+FineReprot7.1,客户端IE11预览效果为: 36558 如果客户端IE为8.0版本及以下则没问题,请问是什么原因呀?
  • 冻结栏目,然后错位,见下图,请问是什么原因(IE10,FR7.1.1): 35761
  • DECLARE @sel VARCHAR(100) DECLARE @dat datetime set @dat=CONVERT(varchar(10), CONVERT(varchar(8),dateadd(month,-2,getdate()),23)+'01' , 120) set @sel='select top 10 * from log where submitdate < '+@dat EXEC @sel; 执行以上语句,提示: 从字符串向 datetime 转换时失败,请问是什么原因造成的?
  • 本帖最后由 tudou 于 2016-3-15 20:57 编辑 如下图,数据库中有两张表,人员信息表humres(姓名,部门等字段),数据填表表table1(姓名、日期、填报内容等字段),我用range()函数生成指定月份的每天的数据行,如何写SQL语句在下表中展示哪些人没有填报数据? SQL语句:SELECT objname,orgid FROM humres WHERE 姓名 NOT IN ( SELECT 姓名 FROM table1 WHERE 日期 LIKE '${kdate}' ) 34479 p1是模板参数,日期型,我在D4单元格过滤为:$kdate=B4,报表预览没有任何数据,请问是什么原因?(在上面的SQL语句中,将参数改成具体日期是有数据的)
  • 本帖最后由 tudou 于 2016-3-2 17:58 编辑 查询结果1 SELECT bm, MONTH (rq) AS yf, YEAR (rq) AS nd, SUM (gs) AS glgs FROM working_hour_detail WHERE bh = '001' or bh='002' GROUP BY rq, bm 查询结果2 SELECT bm, MONTH (rq) AS yf, YEAR (rq) AS nd, SUM (gs) AS xmgs FROM working_hour_detail WHERE bh '002' GROUP BY rq, 需要将两个结果生成 结果1.bm, 结果1.nd, 结果1 .yf, 结果1.glgs, 结果2.xmgs 结果1和结果2中的bm不完全相同 如何写语句?在表中体现如下,我用两个查询语句,放在1个表中,项目工时按部门、年度、月份过滤求和,生成报表太慢了 data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdIAAADMCAYAAADHyyJpAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACWXSURBVHhe7d0J3BZFHQfweQUNLUPSEg9CjZSPWaApGpRiEEaGpKGglAck4olgKGSmpKbklZoJCR/KykCNRPLKI97MlDLxKqhITDtQzCszScj6zbt/GIbZ69l79/f9fObzPs/sPHs8u8/+35mdnW1btGjRWypjBxxwgPeKiIgoXe3t7YXGmU28v0RERNQCBlIiIqIEGEiJiIgSYCAlIiJKgIGUiIgoAQZSIiKiBBhIiVLQ1ta2LoXJqiwRFYOBtEGyPilnPf+6eOutzG/drqWgYyurYy+r+VK9MJA2iHkCz+vEYJ6IoqQmC/s+wqaHcX0+KAWJU9ZPnM+a5VpdHlFWGEgbyq9WJCc3vxQky0Btr0eryY+rrJ2qIK/1tY8fWZ65/LAURxa1eNc62cnkmm4mai4G0hoL+rEHTQOcuCS1Qj5nzscvxeH6PJLJNV1SmYWtb9h0m71PTa55IcURVt6et1+Kyq+suZ1x5keUFgbSBjBPWq4UJO5JKso8W5HVfF1kWWkuT/5ZcQU3M88sZ5cNmibsdfYrl5Ysviuba5tdeWDm29Ns5rr7JZNrupmouRhIa8z8gdsnFvN90hOBzMucfx2Z22knk19+kDhlw9j7Ms15E9HGQgPpwIEDvVdUVUEnUp5ko5N/OFzJ5JcfhflZ+/NB02zm9LCyceGYKeK4Mbc9KMUh2+KXTK7pkqjZAgMpg2g9mCcX+0cf9cQT9wRFbq7vEXmSH3SCtqdJ8mPONy3m8sKWXwXyHfklk2u6JGq2wEC6aNEi7xVVmZzsovzozelVP0m2SgJEEdsv+yhOypNrmU09TogEr5HWlCsYhOWZ+eRWpe8qaD3N7TBTVEUE8TS5tt2VTK7prkTNw0Bac3LCC0suZn6TThBh30sros7PPikHpaikrGsdXO9d5fzEKZuUvf1+iShvDKQ1FfcEF6U8T1IbBp4svw/ZH3aKyly3OJ8rI/s7iJP8uMqayeYq45eoeRhIa07+Sw9LwnwNPDFQWdnHblpcvwHXsiTPzqfmCQyk0muXvXebzQymPGmsl+U/GeZJ2kxlU4Z1cy271XWyP+O3j4vcXiqfwECKXruSqPpwUjATuclJ2O9kmcf3Z+4nM0VhrnfUz7Qiy+XY+8B+bzPz/V4HCZq3yVUmy++YqoFNu0QNYgaCoAAQNbDkxbWufutv5wdth72dQfOUaVHKU7MwkFKoMp1Q8yAnzSJPknKCt1MYs0wa6x91uWlqZRvscvZ7extc2+W3LFdZSOP7pXpgICVfcU42WZF1CEsm13Q7lR2+Z1dKwtzuOPNylW11Xmmzvxdz/ybdxjBVOI4oHwykDSInGfNkE0eaJ8wk65EnOVGnue1Z8lvfON9zXvsky2NA5un3fZj59jSTvW52WXMbJFHzMJA2SNSTh4hbPg7X/Pzyski2oGl+yn7y9Fu/oG2Msi1Rt9dcviuF8VtP17wkZcE+Luz3Jr98qjcGUipc0ImpzFzrnOV2xA0UUdcPeUHJFjTdnhY1mVx5cSX9vAiaj6xnWsui6mIgbTDXiaCVE4NrPlG08pmyMbc9zrb4lQ+aj0wLKmNr5TNlZW9LUEqilfmksVyqLgbSmmvlpEBERNExkBIRESXAQEpERJQAAykREVECDKREREQJMJASERElwEBKRESUAAMpERFRAgykRERECTCQEhERJcBASkRElAADKRERUQIMpERERAkwkBIRESXAQEpERJRA281zZ2b6fK1tuu/mvSIiIqqftkWLFmX+oMoDDjjAe0VN1d7ezuOA1uHxQGkq+nhi0y4REVECDKREREQJMJASERElwEBKRESUAAMpERFRAgykRERECTCQEhERJcBASkRElAADKRERUQKZDxE4YtQJ3isiIqJsLFq0yHuVv1yGCDzhhBNU9+7d1fnnn68+9rGPebnUJG1tbeqttzoOtWnTpqlzzz1XvyYiSso8vxQhl6bdnj17qgcffFCNHj1a7b777uob3/iGevHFF72p1DQIogimSEREVZdLjfRd73qXGjRokP6vYeLEieq3v/2t+slPfqI+/elPq3HjxuVeS121apV697vf7b2jPGDfn3feed67DbF2SkRJNKJG+sEPflB96EMfUhMmTFBXXnmlOuSQQ9Sf/vQn9eEPf1g3++ZZS/3HP/6hRo0a5b2jPCFgShIMokRUdbn12kUQveWWW9RPf/pT/fr2229Xp59+uvrd736nvv3tb6vf/OY36n3ve5/6/Oc/r+6//37vU+nDo3ZQC/7zn/+sXn/9dS9XqTVr1nivKGtyjZRBlIjqILdAevDBB6uXXnpJvfbaa+q+++5TU6dOVbNnz9bTPvrRj6rvfe97mddSp0+frp588kk1cuRIfd0Wzc3PPvusXk7fvn29UhubMmWK94rSwABKRHWS64O9r776avWLX/xCzZs3Ty1fvlwNHjxYnXnmmeqkk07S000oN3PmzNSupf71r39VXbt2Vccee6w69dRTVZcuXXQtdMCAARtdM122bJm67LLL1JAhQ9Tmm2+uexsvXrzYm0qtKPoaBhHVVyOukQoEsXvvvVfXAnv16qXv+0HAuuKKK7wS66VdS91hhx3U3/72N3XBBRfowP72t79dB1M08R5zzDHqv//9r1dS6UC//fbbq06dOqmFCxeq+fPnq3vuuUcdd9xxat9991VvvPGGV5KIiJou10C65ZZbqqOPPlpdc801+v1OO+2k2tvb1YwZM9RFF12k82zo8ZvGtVQETDQtX3LJJfr1hRdeqAM0mnhxvXaTTdZ/FXiP63j77LOPOuOMM9Rmm22m7rzzTrXLLruobbfdVgdgIiIiyLVpF1asWKH69eung9kWW2yh81auXKmvV44YMSLSvYWokV5//fU6sAKafRGgEXSjQs3y5ptvVv/+9791022fPn3UF7/4RT3tyCOPVD/84Q9156hdd91V9e7dW29Dlp2g6o5Nu5S3JMccj9dqaVTTLuy888662RaBUGDUIzTzLliwQJ111llerr+0aqk9evTQgRJNyBJEcX308ssvV3PmzFGrV6/W11X//ve/68BLRK3DyU6Si19+K+KeWO31wmfTXB+qt8BAOnDgwHUpTQiCV1111QYHOjr7oDcvEqZH1cq1VHQuGj9+vPduQ1iv7bbbTl8PRS0VrwHrhVo0EbUGv/c0aw0S/NIIeGmuFzWPb9MugidqicJ+H4fZtCv23HNPdfHFF6uDDjrIy+nwyiuvqKFDh+oBHK699tqWfiSt9vj92c9+pg488EDvXcfgDbiG+8wzz8QK7rQx7EeerAjSOBbMedjza3X+rs+lsa6UvaL3k2+NtNWgGRUGZUCt0YamVAzasHTpUjVmzJgNetNG1WqPXwRRBE/UWNGci569hx12mL5NBk3IuAeWiIplnzQZ6KhooZ2NpFk3SWB11Uhx/RG9dlELRGceG0YdGj58uG7yxfXUzp07e1Nak/S+VARRjBHMa6Wt4X/21YF95YL9J9PMfWnn2Z+397vrWHDN14/r8yZ7epT1Ea5pUdaJilX0forcazftpl3AIObPP/+8+ta3vuXlbAj3a372s5/VgyKgF+2mm27qTWldGj1+KT6ekKrB3E9ZvAb7vfDLt9nzFn7LA/szYa+FK4/Kp+j9lHuvXdOJJ56o5s6dq+/vdMH9mj/+8Y918y6aWFGLbYU5clJaPX6J6ggnI5yUop6YzPJFkHUs8iRK5BtI0+6p64LBDYYNG6ZmzZrl5WwMgyHceOON+nolnhqD+z7jwPi6uDf1pptuUq+++qqX2yGvMX6JqkICaNTAFLd8GrCsoMAdNj0q2TaiMIFNu2YwTfsaqXjkkUfUoYceqp566ik9JJ+ftWvX6s5H6EGL65wIrGFQ00VwRK0XIxehIxE6Mj322GO6x7BL2mP8UgeelKrDDELmPrODk0wLClphQc01D3uZ5nuTfMY13fycPW/7c+Z0MPNd86byKXpf5T6ykcv++++vB5I//PDDvRw3NPHi/k80y2IYv3e+853eFLe9995bPfzww+rxxx/X4+x+8pOfVKeccop++kjYg715LTVdPClVg72fqrzfkqw7j9dqKXp/FXqNVOCaJR74HQa1StQWcQ8qnhzjd20VcF30y1/+svr1r3+t70lFEL300kt1E25YEAVeS6UmwskIJyVJVQ4mSdadQZTiKEUgxW0ueMwZao9h8OPG49hQy/34xz+uXnjhBW9KBzxZBmP2nn322eozn/mMHnge10cBQxBixKK4eC2VmgRBRBIRhStFIMW1UTS5ugZo8IOnuOBh4biO+9xzz+k8/N166631YPR4bJpAk/ERRxyh7rjjDi9nQ2gy/shHPuK988daKhER2UoRSOELX/iCDnQYUSgqPFt01KhRunaKGi16AcsTZUDmhb/9+/dX73jHO/R7EwLipEmT1AMPPKDfR10+a6lERASlCaQYGvCoo47yHZzBD66DIggjmNqDynfr1k3f+oLxfO2xcjE4PZp88RxUBD8MC7jXXnupf/7zn3rwh6hYSyUiarbSBFJAz10EI4xoFAcegYZghmZe1BAFBnTALSzotWs77bTTdMB86KGHdMckDJaPW3HwWDXcJtMK1lKJiJqnVIEUQQydg2644QYvx59cFxW4xvqlL31JDzz/+9//3stVOqC5PPjgg2rkyJG6ORhBFcsWScfTZS2ViKg5ShVIAQEoyq0wCIA/+MEPvHcdjj/+eH3dFL15n3zySS/XDUEXgRQQVM8//3z9Gh2P0BycFtZSiYjqrXSBFPeHYhQjPBUmzJFHHqnvEzVh0ITLL79cfeITn1CPPvqol7sh1AylB++MGTPUv/71L3XOOeeoefPm6Rpjq027QVhLJSKqp7ab587M9GaxbbrvFjqyke26667TQ/Thvk/AtUwETZdjjjlGffe73/XerYfB7jEo/q233qr69evn5a6HXr64LorBGWSABtx/iltn8tKk0ZNw/y8RUVaSDGObVCmGCLRhYPqePXvqJlfU2uDOO+/UoxMJjGqEa5l33323+uUvf+kMtBhGEAMwzJ8/Xw0YMMDL3RCeM/rzn/9c35capRaclbqP8WuOkoOmcwzTSESUhqJH4Sq0aRdNqAheeIi3ecsJnj+KW1owgpHAQ8DXrFmjX+MWmSlTpqg//OEPOuAiiMroRaZPfepT+joqBsX3+28F95bieuu9997r5RSjSddSEUQRTNO8Fl0lqJyzgk5UH7nWSBH40OSK2iU69XzgAx9QK1euVN27d9e9ZnEPJ2piCGxoesUYuStWrFg3OD2CJe7//PrXv77RSES4hxSDMbjG0W1vb9cjGyFQDRkyxMstvzrVUvEfIx7k7tK02qkZRDkKH1FyRddIc2/aRccaCQYIlgiogA4/eDRajx499HtATRPNt+ikI4KulwZBMzHG3p09e7YOSlVSh2up9oEutdE6B9E4tU4GVKLWNa5p973vfa/3SulHm61evVo/vPub3/ymWrJkiTelAwIomncl2AKuk7bSqxY12Ntuu003Gf/oRz/ycquhbj1+5Rpp3Wui+F27ksmVR0TVknsgPfnkk/WgCXik2Xve8x61yy676GH+EEhR+zRvZ8F7lFm4cKGX0zHsH2qlGI3IhmuouO3FD55Petddd+kRlMxrslVSh2upTWvK9cMASlQPuQdSXO9DByM8oBu9c1HTWr58uRo7dqzuiWsHuAkTJuggYcIoRmimNaFnLnroohevq+OR6NOnj7rnnnvU5MmT1Xe+8x0vt3p4X2q1MYgS1Ufu10hxjRLX+772ta+pXr166Y5F6LWLTkdbbrmlbt41OwShlrnzzjvrAIwg6IJrnhjmD/PBgA6oteEeVPTo9YOOT6i9YoQj1OrqoMzXUou+hkFE9dW4a6SoeaIXLXrvIog+9dRTuhcvbm9BIEQgNa+Jdu7cWTcHu4YNXLZsmQ7SCLIIvs8//7y+HxTBIyiIAnoJ45aY6dOnRxqSsApYSyUiyl9hAzKgeRX3giLw4ZppENS0UHvFYPSu21swtB9GN0ITMHr+4qHeGNHokEMO0cEZwdvvmuizzz6rx+bFOL1nnnmml1sfZamlskZKRFkp+vxSipGN0AsXt8IgkOE2GFftCc2vO+64ox4T14aOR/IcU9x7isem4XorrpuihoteoltvvbWe7oKHeSOY4raar3zlK15u/RR5XyoDKRFlpZGBFM25GFgBQ/MBetEikOEeUjyLFA/4RhDcZJP1Lc9orsT1z6efflrfLuMHAzOgWRedkVB++PDhG9yb6gfNwiiPAIPrt3VWRC2VgZTyluSY4/FaLY0MpIAmV4xE5IIa4nbbbee9Ww/XQXG9D8km81u8eLF+JBpqXXD22WerCy+8UL8Og5oxloH1xRNkmiCvWipPTIRjQLiOhTSPkbjzknUzP8NjtjqK3leROhsNHDjQe5UevyAKqImiadaGjjR+HYNGjRqlb4tBb1wJoiBBVAJj0K0xaP7FmLsYBB8dnJrwI+LzUikv+D2l+ZvCyVNSEnISRko6L2qm0BqpBNH/l9N/WxF2jdQFnYDsJlkc6L1799a30CAAmNBcjDF77QBt1m4xgP2sWbNCn/KCMX8PPvhg9f73v18/0s1sYm6CLGqpcrIiSuNYMOdhzy/u/IPKp7GulL2i91NpI8QVV1zhvVoPXxbuF7UHaACMkGQHUfTmRRBF72DcCoKnwOB6LK7D4r0f3M+KB3/jeiyed4oHjTcJa6lUZvZJk4GOihYYSFEbTVITDYN7OE0YfAGdhXArC2qOr776qjdlvWOPPVavE8q54PmiYr/99tNB8+KLL9ZPmkFgxDi7kyZN0kMPBsFtNBib94UXXtC9ed98801vSnPwvtRmQqByJXOayc6T93Z+kDhl47Lnbb43/5pliOLwDaRZB1FcA0VTK8bW3WuvvfQ4uOhpi2ZV3P+JICqPTzMhwGEoQIzN64Lni8o1UvTelXF6u3TpomtWmDfuRZ04caLq27fvumecuuAzGCEJA+uPGDFC/ec///GmNA9rqc2AYIIantTyzNdg1/7M8hKIpIydH0Q+ExfmLcmPa97mOsrfVteByPcaqauDUauB1e8aKToGoRnV1UM3CGqjOJnjLwKrC2qdeNIMxvNFbQrXOnGLDYLhM888o8f3xYO/o0BtdPTo0TrIY0QmBFiKdy0VJzqeqKpBgpK5v8z9Z+9LM4i5yrjKm++FX74tbH6u+Zh5UcqLoGlUHkXvp0i3vyStnbbS2SgMaogIjK6nwJgw3OCMGTN05yEZNhCPVJs7d6664YYb1NSpU3VeGFwnRbMyHv2GUZP8AngTRbkvlSekavDbT2Z+ktdgvxd++S5B8we/PIhSFvzyqXyK3lehnY2kZuqqoRYJ1+4wqEPYl4cet/gn4LHHHtPv0ZSLGiWCatQgCp06ddLXbjEm8NChQ3XtlDrwWmp94PeEk5IkYeaD/HXl22VA8s1p9nTzr7DfC3O5YecA4SpnLtdvWURhChuQIQ1o3sXgC2FNtIMGDdL3h86ZM0dfX7U999xzqmvXrpGabPFjxP2qCBYYbH+rrbbyppDJrqUuXbo08gmPimMHpjiBqmySbEuVt7uJit5flb5BMmiABhMCJSCI2gM9YPB8ebB4FNhh11xzjerfv78O0BgNiTZm11KpGnAywjEuqcrBRNa9lW2p8nZT/iodSEeOHKmeeOIJfbIOsueee64LoOjchJ7CeAQbmoZxX+rVV1+t9tlnn1jDAqLsQQcdpJ9cg3F6yZ89eAaVG4KIpDqo07ZQOVW6aRe++tWv6ifHoPdoGPTYxYD3q1at0s85RXMurqGiZjl58mS1//7761tdunXr5n0iHJaPR7Sh6Xj77bf3cslW9doNEZVX0eeXStdIYfz48Xr83Cj3MiKIosct7iPFMIHyYHAEwcsuu0yPjITrqHHgsWtoMsZ8MKwhERE1S+UDKUYowkAOUa/D4d5S9Nw97LDD9DCEaOqF73//+zoP1/Uw8ADuM40Kz1FFByQE0xUrVni5RETUBJVv2gXc2oIBARDE0GQbBoEStVgEPwwdCDvssIP+e8QRR+jm2t69e+v3caB5Gc8yvfvuu9Wuu+7q5RKwaZeIssKm3RT06dNH9erVS4+jGwXubzz88MP1s0eXLFmijj/+eNXe3q5HL7rxxhtbCqKAYfOmTZumB4oI6wBFRET1UItACmiSdT0Vxg/uPUVPXtRkEVAxTCHG/k0Kox9dcsklavDgwesGgSAiovqqTSAdNmyYvg1l8eLFXk4wPMQbgRMDOiAIp9kUi6fF4JYa3B7z8MMPe7lERFRHtbhGKlAj/dWvfqXH0I3K7ykzacBg7mPHjlW33HKLHt+3yXiNlIiywmukKRozZoy666679H2lUWUVRAHNxujYhF7FuAZLRET103bz3JmZhvFtuu+WW40UJkyYoJ/Mgt6zZYFB89EbGDVlXDttIvzHSESUFZxni1Krpl3Ag6fRjIpnlW6++eZebvEeeOABfZ8qBnyI+hzUOmHTLpl4PFCa2LSbMjy+C4EUAyyUyYABA9TChQt18zMeDk5ERPVQu0AKaN6N8lSYvPXr108/eg0PI583b56XS0REVVbLQIoBETAYPR6RVjZ9+/bVIx9NmjRJP6+TiIiqrZaBFOIO0JCnPfbYQ9133336OajXXXedl0tERFVU20B61FFH6eeO/vGPf/RyymW33XbTT6BB7+KoDxUnIqLyqW0g7dKlixo3bpx+eHdZoWMUumyj5nzppZd6uUREVCW1DaSATj24d/OVV17xcsqnZ8+eerCGWbNmqQsuuMDLJSKiqqh1IMVA9EOHDlWzZ8/2csoJj3BDMJ07d66+bkpERNVR60AK6HSEAeTXrl3r5ZTTtttuq5t5b7vtNjV58mQvl+JyjaAUdVQllPNLLma+32vhN4+okn4+qryWU2f4Dv1SWZRpXeqg9oF077331jW+BQsWeDnltc022+jevKidnnrqqRz5pUWuE5eZJ/n2e8B3Lt+7+dqGz5jT8FrmY74GuywgLyyZ7HkK+zOuJPzyKRn7O8W+kuR6D+Zn/JLJNd1Owi+fsuM7RODAgQO9V+u1OpZhnkMEutx00026Z2xVBo7HE2kwjODuu++uZsyYoe+JrTr8oM0TSRbMZchrV57Jb3rcz0Vlz8dP2DL9BJWx19lVLsoy0pDXcvLi2p6gbQzb/iTTzWl+5cLmXzVFb0/gGRqB00xVhTFun376abVkyRIvp9zwRBo8xQa37hx33HGlb5YuE/ygkOS1/HW9dolSFnn2jxbvw5LNNe8gmEfcz4SRbZQkedQ6+7s0U1Fc61Hk+tRN7Zt2oVOnTurkk08u7QANLniCze23365WrlypRo8erdasWeNNoSB28HKlIGaZKOVBytgnKzOBPS+8l2lFkW2UJHmUjP29ur5T+xgxU9pc6+JaJ2pN5KbdJDXSopt24aWXXtL3bS5dulR37KmK1atXqxEjRqjOnTvr8Xk322wzb0q14OSQ1w836ERkroNZDvnmOvq9Bvt9kChlXWX8Phc2v6DpmGZqZf5pyWs5eTG3J+5rlyTTMc3kKhc2/6opensiN+26rplWSbdu3dSoUaPUtdde6+VUw9ve9jY1f/58Xas+9NBD1RtvvOFNoSD4UdnJJnnmNPwg5URkvm5F1B+3vfwsYVn2OmW9TMof93O+fANpkhpoWZ122mlq5syZupZXJZtuuqm+x7Rr165q2LBh6vXXX/emkB+cNOwURk4+cgKy3/txLQvJNc2PTA9bVhawzKB1o2zIPnelLHA/Z8c3kFa9BurSu3dv/fQVBKWqQdMunrG644476kEmXnvtNW8KuUgAtFMQ+0RmvxeYj5lnLwMpKN8k8/ebbpJyVE72cRJG9rkrUbX4XiMFM5gmqaGW4RqpQG/YKVOmVKYHrw0/shNPPFE9/vjj6o477tC11CrIMwiEndDM9ZCy9rqFrW+S6eb6BZWJu04QdbngKhdlGWnIazl58NsWyXdND9v+JNMxzeQqFzb/qil6eyJfI62LIUOG6KbdqtxTasMBg3tL8ZDwwYMHqxdffNGbQib8qFzJJCccOz8KfMY+YUXltz5B0jpRxF0uhXN9n+b+wl/XsYI8v5QU93O+GnH7iwkHKa6VXnnllV5ONeFWHjzAHGnVqlVeLgn7xCTJZJ5sXOXs9zbXiSqofBhzefa8g5ZlpqB8cx72/Mxy1Dr5Hl37z/5+keeXTDJPMwXlm5/3mxelq3GBFI4++mh1//33qxUrVng51TR9+nQ1fPhw3QSP+02pg3lCciUXVzkzRdXKZ0Tcz5rlw1KYOGXJX9B3aOaHfc922agpTJyyFF0jA+kWW2yhxowZowezr7pp06apz33uc/o69F/+8hcvl4iI8tLIQAqnnHKKuv7662vR+3Xq1Klq/PjxOphiKEQiIspPYwNpjx491KBBg9ScOXO8nGqbOHGiOuOMM3Qz7/Lly71cIiLKWmMDKUyYMEFdddVVtblecNJJJ6lzzjlHHXjggWrZsmVeLhERZanRgbR///566EA8TLsuxo4dqy666CLdm/eJJ57wcomIKCuNDqRw+umnV+qpMFGg8xFu78E9s4888oiXS0REWQgc2SgtZRrZyPbmm2+qnXbaSY94tMcee3i59bBgwQI1btw4deutt6p9993Xyy0G7l1jl3sCORZ4PyOlRY6nos4xbTfPnZnpkkeMOsF7RUQUfg8lUSvQ0RK3Axahbe2ybAPp/St3W1cjxUaee+65+jU1C2ukJFgjpbQVXSPN5xpp234dyXz9/9SmFjsTETUDTnxMTElSGeQSSKedN9R71UG/f+sh792G3lLFXssjIiKKI5+m3YFnbRBMpXnXrn0yiNYXm3ZJmE27PCYoqTIcT6W5/YVBlIiIqii3QHrueXd0/HV0NmIQJSKiqsqvRvrWQwyiRERUO/kEUnYsIiKimirNNVIiIqIqyj2QttXoHmz0EmtVks9S/ZmHR9ihEvdQyvPQ42FeDjyeslWrGimCkySXNIMX5iVdrYOW6Ue6a1N1YfdJcklr9+Iws+dlLjtOj/8o5c15J+Va96qr+vbkfTylqazHU2gg7dT7BJ2qAMEpzfuIJECGBbyi7l2iYmG3p7HrcXjZyc6X98K1bLO8pFaktV1UDL/jwPVeZHk8NUFgIEUAXbtspk5VCaZB4gQ8BE+/wCzTksI8woI0VVfUQwTl7BSUHySoLA61KPNIG5ZZp8O8iO8wDtn/ZgrKDxJUlsfTer6BVIKoMF/XnR0o0wiaREFcJwYzz34tyXxPJFzHg5lnv5ZkvqfoCmnaRaByJXOayc6T93Z+kDhlW2UvQ97b+ZQvfPWuZE4z2Xny3s4PEqcsBP2XjXzzfzm8lmS+b5Wsq6QwrvKuvKoyt8HeHvu9ya+snS/s6XYS5nt7mh8cD37lkG8eL3L8SJ75Og5z3VyvzTyTa7orr8wKadpFDU9qeeZrsGt/CEBSRoKRlLHzg8hn4pIgGHUZ9vrIcqOuJ6ULXzl2gbcbNngN5mswy8vukjJ2fhD5TBzyGXO5sj4uUi7K+viR+csy/JYlgspLvplXRfb629voYn4vsj+krJ0Pft+j+deeD5ivw0hZcz6yXBcpJ3/jsudrvpfXsg5C1secLiTfzCurwECadnOuuaM6vsDwb0gCUFFByAyEVD3YbeuPNy8zgFm+CFHX0ywn69wKc3ujLNevvJlfB7I9Ub4TiLv9Zvmoy2hF1Pmb5WTdWiGfjbpNUt7+jJlfBaE10qxE/aIRQBHE8gxkErz9hE2PSraNsoPdhK846tcct3yaZNkmvLcPNb9yYYLmFeXzEFRe8qOsb9nJOtvb4ifoe3GJW74Vru8d7+1t8isXJmhedr4fKe9anuT7LaNMfAOp1EblGmkatVNz4xFEzGAkwUny5K8r3y4Dkm9Os6ebf4X9XpjLjRrs4pan7GFXYBdLEmY+yF9Xvl0GJN+cZk83/wr7Pchn/Q4bWSfhVw5kXmb5IOb2ymf8XoOrPLjyqsreBns7zb/C/F7Afi3ktd/36Mc1f/OvScrhMy4yL+FXDmReZnk/dpkon/H7Hlx5ZZbP80gPOMB71/HFmDuuyoEnybo3LeAWtb0bH2/BJ46ycK1nWF7UbW3lMyJpeZBjoWm/AVPc7zEp934Izou6jn75UURdhnBNL8PxFNprN23YTmywpCr/kJKse1NPIHnrON7Wpyp87VhPl7B1t6f7lTfz8TrO99NKedpY3O8xCczfJe6+8yufZN3x2TjfQ5JlZSn3QAoIIpKIsiI/TpP5oy1rEq5pdopaLiiZXNPtZHJND0tl/9m71jmLZHJNTysJ1zQ7RS2XZjK5poelMhxPhQRSojzgB8ZUvoSTX5m51pmpvKkMxxMDKREVY9//nwWJaoCBlIiKs7jk1VOiCBhIiahYDKZUcQykRFQ8BlNqETqtFn0HCAMpEZUDgynFZN5GKa+LkPuADNRMRf/HSOWx7sS3n5dhY0ClCCR4ul7nre3mudkG0hGjqv9AcCJKD/+hojTY/5wPHDhQ/502bZr+m6e2l19+OdOj+tFHH2WNlFR7ezuPA9JwAsSxgGOCqFVmLdQ8nor4R43XSIkoVzjRodaAv0xMraYyYSAlIqJKkqBq/mNWBAZSIiKiBBhIiYiIEmAgJSIiSoCBlIiIKAEGUiIiogQYSImIiBJgICUiIkqAgZSIiCiBwEC61VZbbZCIiIhoQ4GB9OWXX16XiIiIaGORmnZRG2UwJSIi2hivkRIRESUQGkhZGyUiIvLHGikREVECDKREREQJMJASERElEBpIeX2UiIjIH2ukRERECTCQEhERJcBASkRE1DKl/gd3kgRM6D9rWwAAAABJRU5ErkJggg==
  • 在报表中利用坑爹的函数DATEDIF(出生日期,截至日期,“Y"),其实际结果居然是=YEAR(截至日期)-YEAR(出生日期),如果用=ROUNDDOWN(DATEDIF(出生日期,截至日期,"D")/365,0)并不准确,请问各位还有更好的办法吗?
  • 本帖最后由 tudou 于 2013-9-12 14:41 编辑 数据库中有一张销售信息的表,其中有个字段为收款日期,收款日期需要从exceL中导入,在报表模板中将收款日期设置了日期控件(如下图),但是excel的数据不规范,日期正常格式为yyyy-mm-dd,部分数据位yyyy.mm.dd,或者yyyy.mm,导入时,报表仍然通过了校验,并且能够提交成功。请问是什么原因呀?(我用的是7.0版本) 13390

31

51

31

10

个人成就
内容被浏览68,543
加入社区11年225天
返回顶部