易表在线答疑技术与交流用户社区 → [讨论]简化打印公式


  共有6364人关注过本帖树形打印复制链接

主题:[讨论]简化打印公式

帅哥哟,离线,有人找我吗?
jdw814520
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:189 积分:1100 威望:0 精华:0 注册:2006/10/15 14:22:00
[讨论]简化打印公式  发帖心情 Post By:2012/10/28 9:52:00 [只看该作者]

下面的打印公式能正常打印,就是嫌公式太长,各位高手能帮忙简化一下吗?

 

OpenGrid("初三")AndSortCol("姓名",1) And FilterFor("班级", "=" ,1) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=", 2) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,3) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,4) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,5) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112)And FilterFor("班级", "=" ,6) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,7) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,8) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,9) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,10) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,11) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,12) And Report(grid,"各班成绩册空表",1,rows,2,2) And Do(112) And FilterFor("班级", "=" ,13) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,14) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,15) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,17) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,18) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,19) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112) And FilterFor("班级", "=" ,20) And Report(grid,"各班成绩册空表",1,rows,1,2) And Do(112)


 回到顶部
帅哥哟,离线,有人找我吗?
wjq1072
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:16190 积分:125850 威望:1 精华:0 注册:2006/8/12 12:29:00
  发帖心情 Post By:2012/10/28 10:05:00 [只看该作者]

这样试试?

OpenGrid("初三")And SortCol("姓名",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)")


 回到顶部
帅哥哟,离线,有人找我吗?
jdw814520
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:论坛游民 帖子:189 积分:1100 威望:0 精华:0 注册:2006/10/15 14:22:00
  发帖心情 Post By:2012/10/28 11:59:00 [只看该作者]

谢谢了


 回到顶部