2013年3月14日星期四

How to pass temp table from Form to report

method 1
dierct pass element from the form's tmptable datasource to the report's datasource on queryrun.setCuror.

public boolean fetch()
{
queryRun qr;
FormDataSource formDataSource;
;

qr = new QueryRun(this.query());

if (qr.prompt())
{
formDataSource = element.args().record().dataSource();
qr.setCursor(formDataSource.cursor(),1);

while (qr.next())
{
tmpAssetConsumptionProposal = qr.get(tableNum(TmpAssetConsumptionProposal));
this.send(tmpAssetConsumptionProposal);
}
return true;
}

return false;
}
-------------------------------------------------------------
using pass paramters element to report
RecordSortedList sortedList1;
Args args;
;

args = new Args();
sortedList1= new recordSortedList(tableNum(table1));
while select table1
{
sortedList1.ins(table1)
}
args.caller(element);
args.object(sortedList1);
new MenuFunction(…).run(args); //pass to report


on report
Table1 table1;
recordSortedList sortedList1;
;
sortedList1 = element.args().object();
if (sortedList1.first(table1))
print table1.field1;
while(sortedList1.next(table1))
{
print table1.field1;
}

没有评论:

发表评论