Finance | Project Operations, Human Resources, ...

RDP with AOT query in Ax 2012 r3

(0) Share

Report

Posted on by @rp@n

HI al,

i have made SSRS report RDP based with Query

[
    SRSReportQueryAttribute (querystr(GDJ_JPN_VendQR)),
    SRSReportParameterAttribute(classStr(GDJ_JPN_VendorTransactionContract))
]
class GDJ_JPN_VendorTransactionDP extends SrsReportDataProviderPreProcessTempDB
{
}

i have mentioned Query here

ProcessReport method

[SysEntryPointAttribute(false)]
public void processReport()
{
    ;
    contract = this.parmDataContract() as GDJ_JPN_VendorTransactionContract;

    if(contract)
    {
        fromDate    = contract.parmfromDate();
        toDate      = contract.parmtoDate();

        this.insertDataTmpTable(fromDate,toDate);
    }
}

InsertDataTempTable method

public void insertDataTmpTable(transdate   _fromDate,
                        transdate   _toDate)
{
    VendTrans   vendTransOpng;

    boolean     flag;
    query = new query();

    qbds    = query.addDataSource(tableNum(VendTrans));
    qbds.relations(true);

    // date range mapping
    if(_fromDate && _toDate)
    {
        qbds.addRange(fieldNum(VendTrans,TransDate)).value(queryRange(_fromDate, _toDate));
    }

    qbds.addRange(fieldNum(VendTrans,AccountNum)).value();

    qr = new QueryRun(query);

    while(qr.next())
    {
        vendTrans = qr.get(tableNum(VendTrans));
    }
}

here in dialog i am given

3113.vendor.jpg

Note - date filter is working fine BUT the Vendor account which i am given in query is NOT FILTERING data based on vendor.

Please let me know how to resolve ?

please give me more shed on this.

thanks!

I have the same question (0)

All responses (5)

Answers (0)

Sort by

@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!
I have modified the insertTempTable method

public void insertDataTmpTable(transdate _fromDate, transdate _toDate) { VendTrans vendTransOpng; boolean flag; query = this.parmQuery(); qbds = query.addDataSource(tableNum(VendTrans)); qbds.relations(true); // date range mapping if(_fromDate && _toDate) { qbds.addRange(fieldNum(VendTrans,TransDate)).value(queryRange(_fromDate, _toDate)); } qbds.addRange(fieldNum(VendTrans,AccountNum)).value(); queryRun = new QueryRun(query); while(queryRun.next()) { vendTrans = queryRun.get(tableNum(VendTrans)); } }

but still it's not FILTERING VEND ACCOUNT

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

I debugged the query

in the above query, i have required, the Vendor account which i am given in query that should match with VendTrans.AccountNum. So, that it will fetch the record based on ( date range + AccountNum ) from vendTrans.

Please give me more shed on this.

thanks!

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!

Hi

Is your query having vendtable as a single datasource?

If not, then you need to use, query.datasourceno(1).adddatasource(your table) to make the right connection.

Uday

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

yes, single data source ( vend table )

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,175 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Adding new data sources as a joining data source shouldn't be added directly to the query (query.adddataSource)

public static void query(Args _args) { Query query; QueryRun queryrRun; QueryBuildDataSource qbdVendTrans, qbdsVendTable; QueryBuildRange qbr; VendTrans vendTrans; query = new Query(queryStr(Your Query)); //Solution 1 //qbdsVendTable = q.dataSourceTable(TableNum(vendTable)); //qbdVendTrans = qbdsVendTable.addDataSource(TableNum(VendTrans)); //or qbdVendTrans = query.dataSourceTable(TableNum(vendTable)).addDataSource(TableNum(VendTrans)); //Solution2 //qbdVendTrans = query.dataSourceNo(1).addDataSource(TableNum(VendTrans)); qbdVendTrans.relations(true); qbdVendTrans.joinMode(JoinMode::InnerJoin); qbr = qbdVendTrans.addRange(FieldNum(VendTrans, AccountNum)); qbr.value("1000000"); queryrRun = new QueryRun(query); while (queryrRun.next()) { vendTrans = queryrRun.get(tableNum(VendTrans)); info(strFmt("%1", vendTrans.AccountNum)); } }

Uday

Was this reply helpful? Yes No