Hi martin…
Here’s the screen shot:
then Here’s my ProcessReport Code:
[SysEntryPointAttribute(false)]
public void processReport()
{
QueryRun queryRun;
Query query;
QueryBuildRange daterange;
InventSum inventSum;
InventDim inventDim;
InventDimParm inventDimParmCriteria;
InventDimParm inventDimParm;
InventDimViewContract dimContract;
ReqItemTable reqItemTable;
AttributeValueText attributeValueText;
ModifiedDateTime _FromDate, _Todate;
dimContract = this.parmDataContract() as InventDimViewContract;
_FromDate = dimContract.parmFromDate();
_Todate = dimContract.parmToDate();
inventDimParm = dimContract.parmInventDimParm();
inventDimParm.ItemIdFlag = NoYes::Yes;
inventDimParmCriteria.ClosedFlag = NoYes::Yes;
query = InventSum::newQuery(this.parmQuery(), ‘’, null, inventDimParmCriteria, inventDimParm);
dateRange = SysQuery::findOrCreateRange(query.datasourceTable(tableNum(InventDim)),fieldNum(InventDim, modifiedDateTime));
dateRange.value(SysQuery::range(_FromDate,_Todate));
queryRun = new QueryRun(query);
while (queryRun.next())
{
inventSum = queryRun.get(tableNum(InventSum));
if (InventTable::find(inventSum.ItemId).inventItemType().mustInventBeControlled())
{
inventDim = queryRun.get(tableNum(InventDim));
}
if (!InventTable::find(inventSum.ItemId).inventItemType().isServiceItem())
{
this.insertTmpTable(inventSum, inventDim, reqItemTable, AttributeValueText);
inventDim.clear();
}
}
}
I don’t know what is wrong on my code? …
because I’m using that kind of parameter in other report I create and it works fine…
this is the first time I encounter this error…