Sometimes it might be useful to display a query you have created in the AOT to the user. After this the user makes changes to the query (adds ranges and sort fields) and you would like to save the query (as changed by the user) to a table in the database, therefore saving the state…
Tag: Query
Microsoft Dynamics Ax
X++ code to Count Records in Query
by Bo Jensen •
Following code illustrates how we can use SysQuery::countTotal() method to get the number of records in Query. static void Query_cntRecords(Args _args) { Query query = new Query(); QueryRun queryRun; QueryBuildDataSource qbd; ; qbd = query.addDataSource(tablenum(CustTable)); queryRun = new QueryRun(query); info(strfmt("Total Records in Query %1",SysQuery::countTotal(queryRun))); } Microsoft Dynamics…
Microsoft Dynamics Ax, SQL Reporting Services
Dynamics Ax Internals: Quick walk-through of developing a report in Ax2012
by Bo Jensen •
The following is a quick-and-dirty approach to building a basic SSRS report in Ax2012. This uses an Ax query as the primary datasource, and uses display methods on the table(s) to retrieve additional information. This is not an approach you should take for all reports, particularly those that require more complex calculations or parameters, but…
Microsoft Dynamics Ax, SQL Reporting Services
Simple SSRS report example by using Ax-Query and Ranges
by Bo Jensen •
In this report I am going to use the Ax-Query in the SSRS business logic and report will be generated by using SSRS Business logic.