AX / D365FO – Create a simple SSRS Report based on a Query

First, you need to create a query. Open Visual Studio as administrator. From the File menu, select New > Project. Select Dynamics 365 on the left pane. select Finance Operations in the middle pane. Enter ReportingProject in the Name field. Select OK. In the Solution Explorer, right-click your project node, and then select Add > New Item. Select Data Model and then select Query. For the Name field, enter CustTableQry and then select Add. Open the … Continue reading AX / D365FO – Create a simple SSRS Report based on a Query

AX – D365FO – How to solve error : “The business logic assembly …….., Version=1.0.0.0, Culture=neutral, PublicKeyToken=null does not contain a class for report …….” in a SSRS Project

If this error occur : "The business logic assembly .................., Version=1.0.0.0, Culture=neutral, PublicKeyToken=null does not contain a class for report ............................................." just double click on any data method to solve the problem. Then you can deploy your project

AX / D365FO – Execute a SSRS report in batch mode

If you have a report that takes a long time to complete you can consider running it in "batch mode" To reach this result you must call the parmExecutionMode(SysOperationExecutionMode::ScheduledBatch) method in the main Method of the report controller class. For example you can do this public static void main(Args _args) { TaxReportController_IT controller = new … Continue reading AX / D365FO – Execute a SSRS report in batch mode

AX – D365FO – Error : Setting Server Report parameters in Ax 2012 (rsItemNotFound)

Scenario: when I am trying to open a report in AX 2012  R2 CU7 it is displaying an Infolog with an error. "Error while Setting server Report parameters and the report cannot be found(rsItemNotfound)" Solution: Make sure that the reports are deployed and all are in the correct layer. In order to deploy a report, procedure is Open a … Continue reading AX – D365FO – Error : Setting Server Report parameters in Ax 2012 (rsItemNotFound)

AX – D365FO – SSRS report parameters duplicating (appearing twice) in AX2012

Open your report in Visual Studio and under Parameters node, check if your parameter is repeating. If yes, delete one. Most of the time it happens during development when you are changing code again n again. It cahces your previous code and shows new and previous both. In this case : Clear all of your … Continue reading AX – D365FO – SSRS report parameters duplicating (appearing twice) in AX2012

AX – D35FO – Batch processing of reports and setup of alerts

In Finance and Operations apps, any of the reports or actions can be set to run as a batch job by going to the Run in the background section of the report's parameter pane. Set Batch processing to Yes, then provide a batch task job name, batch group, and whether the job should run as Private or Critical. The report … Continue reading AX – D35FO – Batch processing of reports and setup of alerts