内存溢出问题 - 用户社区 - 易表在线答疑 - 简单实用的数据管理软件|数据统计软件|数据分析软件|电子表格软件

使用易表，连接远程打印机，在打印时，总是提示内存溢出，是什么原因？

打印按钮公式为：

FilterFor("全员生","=","0101",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0102",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0103",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0104",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0105",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0106",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0107",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0108",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0109",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0110",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0111",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0112",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0113",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0114",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0115",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0116",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0117",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0118",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0119",2) And Report(GridName,"主观客观总成绩",1,Rows,1)And

FilterFor("全员生","=","0120",2) And Report(GridName,"主观客观总成绩",1,Rows,1) And ShowAllRows()

[此贴子已经被作者于2014-6-9 14:58:18编辑过]

报表打印函数，比PrintReport更加灵活。

语法
Report(Grid,Report,StartRow,EndRow,Output,Option,Printer)
Grid     指定表，可以用表名表示，也可以用位置表示。
Report   报表名称
StartRow 打印起始行
EndRow   打印结束行
Output   设为0，打印预览，设为1，直接打印，设为2，出现对话框
Option   可选参数，1分组换页，2自动满页，4仅打印选定区域的分组行，参数可以组合，例如设为3(2+1)表示同时要分组换页和自动满页。
Printer 可选参数，指定打印机。可以用函数Printers 获得当前计算机的所有打印机。

我现在用的就是Report这个函数，且远程打印机只有一台，这个公式有问题吗 ?

先试一下哪个公式？

公式中Report(Grid,Report,StartRow,EndRow,Output,Option,Printer)第七个参数（红色标识的）加上...

这样对吗？？？

[此贴子已经被作者于2014-6-12 14:50:10编辑过]

Printer 可选参数，指定打印机。可以用函数Printers 获得当前计算机的所有打印机。

Printers

返回指定编号打印机的名称。

例如

Printers(2)
返回第二台打印机的名称

Printers(0)
返回所有打印机的名称，名称之间会用符号"|"隔开

话又说回来，你计算机本身只连了一台打印机，应该不用设Printer参数。还是那句话，公式修改后测试一下，不行传文件大家帮测一下。

主题：内存溢出问题

Printers