效果:
1.DP添加属性
SRSReportQueryAttribute(queryStr(your query Name))
2.修改DP类在processReport()方法中添加以下代码:
QueryRun queryRun = new QueryRun(this.parmQuery());
ttsbegin;
while (queryRun.next())
{
inventTableParameter = queryRun.get(tableNum(InventTable));
inventJournalTrans = queryRun.get(tableNum(InventJournalTrans));
inventJournalTable = queryRun.get(tableNum(InventJournalTable));
inventTable = queryRun.get(tableNum(InventTable));
inventDim = queryRun.get(tableNum(InventDim));
inventBatch = queryRun.get(tableNum(InventBatch));
countingReportTmp.clear();
countingReportTmp.InventLocationId = inventDim.InventLocationId;
countingReportTmp.insert();
}
ttscommit;
3.
要注意报表中的数据源的Dynamic Filters值为True
参考文档: