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)

@rp@n 30 on at

Like (0)

Report
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 30 on at

Like (0)

Report

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,133 on at

Like (0)

Report

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 30 on at

Like (0)

Report

yes, single data source ( vend table )

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,133 on at

Like (0)

Report
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

Join the conversation

Community site session details

RDP with AOT query in Ax 2012 r3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

RDP with AOT query in Ax 2012 r3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates