Passing parameters from Form to AOT Query AX 2012

Question

I am currently on AX 2012 R2. I currently have a custom query object in the AOT that I am using to supply data to a custom SSRS report.

In the SalesTable form, I have a custom button on the SalesTable form in which I overridden the clicked method to call out to a custom Output Menu Item, to supply parameters of SalesTable.CustAccount and SalesTable.SalesId.

However, when I select another record on the SalesTable form and click the custom button, the query dialog displays (dialog for selecting exact values) as normal, but the last selected values for my parameters are still intact. I assume due to usage data.

With creating SSRS reports with Queries, is there a way supply the current selected record values from a form to the dialog as parameters, rather than what is held in usage data?

Please advise and thanks in advance

void clicked()
{
    MenuFunction            jobCardReport;
    Args                    args = new Args();
    Query                   query = new Query();
    QueryRun                queryRun;
    QueryBuildDataSource    qbds;
    QueryBuildRange         queryBuildRange;
    SalesTable              salesTableRecord;
    ;

    salesTableRecord = element.args().record();
    qbds = query.addDataSource(tableNum(SalesTable));
    queryBuildRange = qbds.addRange(fieldNum(SalesTable, CustAccount));
    queryBuildRange.value(salesTableRecord.CustAccount);

    queryBuildRange = qbds.addRange(fieldNum(SalesTable, SalesId));
    queryBuildRange.value(salesTableRecord.SalesId);
    queryRun = new QueryRun(query);

    jobCardReport = new MenuFunction(menuitemOutputStr(TestCard), MenuItemType::Output);
    args.parm(strFmt("TestCard_DynamicParameter=%1, %2", salesTableRecord.CustAccount, salesTableRecord.SalesId));
    jobCardReport.run(args);        

    super();
}

The last 3 lines of code allowed me to pass manual selections from the query dialog using the "Select" button. But on subsequent runs, the manual selections remain despite which record is displayed in the SalesTable form.

score 1 · Accepted Answer · answered Nov 27 '13 at 09:17

I think the best way for your situation is using SrsReportRunController class. Inside the class, there is a method, name : prePromptModifyContract. This method could contain parameter from SalesTable form, pass it to Report Contract class and process the query inside Data Provider class.

Here is some reference :

I hope this explaination and reference could give you different point of view.

Thanks for the reference, I was able to accomplish what I needed using the SrsReportRun class as well. I will keep this one in mind. — AX_Dev, Dec 02 '13 at 21:50

score 0 · Answer 2 · answered Nov 22 '13 at 09:30

0

Could you please provide code example?

I assume that now you work with query(), but in order to get runtime filter values you should use queryRun(). Both are available from datasource.

answered Nov 22 '13 at 09:30

Yuriy

84
3

Thanks for your response, I edited my initial question with what I used in the custom button's clicked method. – AX_Dev Nov 25 '13 at 18:23

Passing parameters from Form to AOT Query AX 2012

2 Answers2