以文本方式查看主题

-  易表在线答疑  (http://egrid2000.com/dvbbs/index.asp)
--  用户社区  (http://egrid2000.com/dvbbs/list.asp?boardid=2)
----  公式不运行问题  (http://egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=26181)
--  作者：jdw814520
--  发布时间：2013/8/1 14:23:00
--  公式不运行问题
OpenGrid("初一") And SortCol(Grid,"名次",1) And Eval("FilterFor(""班级"","" = ""," + Substitute(ListFor(Grid,"班级",1)," | ",",2) And Report(Grid,""分班成绩册"",1,Rows,2,2) And FilterFor(""班级"","" = "",") + ",2) And Report(Grid,""分班成绩册"",1,Rows,2,2)") And Do(112)
这个公式在13.10版里怎么不运行哟
--  作者：dancedy
--  发布时间：2013/8/1 14:48:00
--  

试试：

OpenGrid("初一") And SortCol(Grid,"名次",1) And Eval("FilterFor(""班级"","" = "",""" + Substitute(ListFor(Grid,"班级",1)," | ",""",2) And Report(Grid,""分班成绩册"",1,Rows,2,2) And FilterFor(""班级"","" = "",""") + """,2) And Report(Grid,""分班成绩册"",1,Rows,2,2)") And Do(112)
--  作者：jdw814520
--  发布时间：2013/8/1 16:10:00
--  
我用的易表还是13.10版的，公式里所有的函数都有，但还是不行呀？怎么回事哟？
--  作者：wjq1072
--  发布时间：2013/8/1 18:59:00
--  

OpenGrid("初一") And SortCol(Grid,"名次",1) And

Eval("FilterFor(""班级"","" = ""," + Substitute(ListFor(Grid,"班级",1)," | ",",2) And Report(Grid,""分班成绩册"",1,Rows,2,2) And FilterFor(""班级"","" = "",") + ",2) And Report(Grid,""分班成绩册"",1,Rows,2,2)") And Do(112)

============================================

这样试试？

OpenGrid("初一") And SortCol(Grid,"名次",1) And

Eval("FilterFor(""班级"",""="","""+Substitute(ListFor(Grid,"班级",1),"|",""",2) And Report(Grid,""分班成绩册"",1,Rows,2,2) And FilterFor(""班级"",""="",""")+""",2) And Report(Grid,""分班成绩册"",1,Rows,2,2)") And Do(112)
--  作者：jdw814520
--  发布时间：2013/8/1 20:06:00
--  
这个公式怎么也不运行哟？           EvalFor(GridName,"考号","") And EvalFor(GridName,"考室","")And SortCol("总分",2) And EvalFor(Grid,"考号","Row") And Eval("EvalFor(Grid,""考室"","""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute(ListFor(Grid,"班级",1),"|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""",1,CountFor(Grid,""班级"",""="","),"|",")) And SortCol(""考室"",1) And EvalFor(Grid,""考室"",""")+")) And SortCol(""考室"",1)") And SortCol("考号",1) And EvalFor(Grid,"考室编号","CountFor(Grid,""考室"",""="",[考室],1,Row)")
--  作者：wjq1072
--  发布时间：2013/8/1 20:34:00
--  
发文件看看？
--  作者：jdw814520
--  发布时间：2013/8/1 21:01:00
--  
这个公式怎么也不运行哟？           EvalFor(GridName,"考号","") And EvalFor(GridName,"考室","")And SortCol("总分",2) And EvalFor(Grid,"考号","Row") And Eval("EvalFor(Grid,""考室"","""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute(ListFor(Grid,"班级",1),"|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""",1,CountFor(Grid,""班级"",""="","),"|",")) And SortCol(""考室"",1) And EvalFor(Grid,""考室"",""")+")) And SortCol(""考室"",1)") And SortCol("考号",1) And EvalFor(Grid,"考室编号","CountFor(Grid,""考室"",""="",[考室],1,Row)")


 下载信息  [文件大小：   下载次数： ]
图片点击可在新窗口打开查看点击浏览该文件:11.egd

 


我用的易表还是13.10版的,请附公式。你们回复的例表我打不开哟。

[此贴子已经被作者于2013-8-1 21:04:52编辑过]
--  作者：wjq1072
--  发布时间：2013/8/1 21:15:00
--  
想得到什么结果？看不懂你的公式啊！
--  作者：jdw814520
--  发布时间：2013/8/1 21:25:00
--  

文件里有说明的哟

 
--  作者：jdw814520
--  发布时间：2013/8/1 21:27:00
--  

这是你之前帮我写公式的地址：

http://bbs.egrid2000.com/dispbbs.asp?BoardID=2&ID=22157&replyID=&skin=1