how to give range on ax report

hello guys

 

Iam trying to give Invoiice Accountrange but it does not work on report.Am I missing something?

class declaration;

VendInvoiceAccount VendAccount;


qbr = sysquery::findOrCreateRange(qbd,(fieldNum(VendInvoiceJour, InvoiceDate)));



qbr.value(sysQuery::range(Fromdate,ToDate));

qbr2= SysQuery::findOrCreateRange(qbd,(fieldNum(VendInvoiceJour,InvoiceAccount)));
qbr2.value(SysQuery::value(VendAccount));



while(qr.next())
{
VendInvoiceJour = qr.get(tablenum(vendInvoiceJour));

select localTaxTrans
where localTaxTrans.TransDate == vendInvoiceJour.InvoiceDate &&
localTaxTrans.Voucher == vendInvoiceJour.LedgerVoucher;
}

Related
Recommended