AX 2012: Data method in SSRS-report based on query - how to access current record?

This question is not answered

Hello,

I'm to add a column to a standard report in AX 2012 which is based on a query. This column is based on a table method implemented in X++. For that I have to add a data method to the report in VS. I've already found the documentation on msdn how to do that. However I now have two problems: how can I access the record currently processed in the data method, because the data method has to be called for this record to be able to return the resulting value and thus showing it in the respective line on the report? And how can I call a (instance-)method implemented on a table in X++?

Regards
Patrick

All Replies
  • i don't think you can get a col based on a table method via data method since data method can only execute an ax query.

    User is able to choose a display method defined in table when creating report dataset based on a query in vs.  Take CustTable table for example,

       Create a query based on the table.

       In vs, add a report dataset of type Query.

       Double click the new dataset and click the newly added query and next.

       You are able to pick display methods defined in CustTable table under All Display Methods node.

    A display method has key work display defined in the method.  You can refer to AOT >> Data Dict >> Tables >> CustTable >> Methods >> address