Musing's of ERP Consultant
D365OF / Dynamics 365 for finance and operations / Dynamics 365 for Operations / Dynamics AX (AX 7) / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 7 / Tips and tricks
by alirazazaidi · Published April 11, 2019
Hi all, small tip. I faced this issue, when I extend the custom report in D365 for finance and operations. During development on onebox Solution was simple, restart IIS services Restart Reporting...
Dynamics 365 for finance and operations / Dynamics 365 for Operations / Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side / Dynamics Ax 7 / MS Dynamics Ax 7 / Sql server reporting services / Tips and tricks / TSQL
by alirazazaidi · Published September 29, 2017
Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for analysis. he wants...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / MS Dynamics Ax 7 / Tips and tricks
by alirazazaidi · Published July 3, 2017 · Last modified February 25, 2018
There is again small tips. Let me share you again scenario. Suppose you have to show customer Sale With customer group level. And group footer want to sum of Sales of that group. Now...
Dynamics 365 for Operations / Dynamics AX (AX 7) / Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published July 3, 2017
Today I have small tip. Let me share a scenario. Suppose you have to display Customer group as report level group and customer at detail level who did purchased products from your organization in...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published February 24, 2017
Let discuss real time scenario. In one of my custom SSRS report, Client wants to open Saleorder form by clicking on Customer Account, By default it leads to customer detail form. I used following...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published December 6, 2016
On running report, following error message appear in info box. The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published October 28, 2016
I was developing the report by adding UI Class and building the drop down list to select multiple customer. When I try to bind, DataSet of SSRS report to data provider class, it...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Sql server reporting services / Tips and tricks
by alirazazaidi · Published August 4, 2016
Hi, all very small tip today, Recently I have to add water mark in one of custom report. In SSRS for Dynamics Ax 2012, we can achieve water mark by adding background image in...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published July 14, 2016
Yesterday I deployed the new SSRS customization to staging, so QA / Functional guy can test. Client configured the AOS to Database server and Application server was moved for backup services. Due to change...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published June 13, 2016
Hi, All, today I have to modify the report. Interestingly this report was built on AOT Query, instead of Data provider class. Current Scenario I was working on Worker Report. The requirement was to...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published July 4, 2015
Today I got this strange error “An item with the same key has already been added “, Very interestingly I got no error during compilation or deployment of report when I run the report...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published July 4, 2015
In Microsoft Dynamics Ax 2012, we can create less complex reports with AOT Query or Static Query. Simple or model based report is as follow. http://dynamics-ax.blogspot.com/2011/12/ax-2012-ax-ssrs-report-design-concepts.html The steps are as follow We can...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Tips and tricks
by alirazazaidi · Published June 1, 2015
Today I got very this error on deployment of customized SSRS report. The customization code was written in Dynamics AX 2012 R2 and it was successfully migrated to Dynamics Ax 2012 R3 System.Web.Services.Protocols.SoapException:...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published October 12, 2014
Recently installed the SSRS report extension on my VM Dynamics Ax 2012 R2 CU7. During installation, I continuously found following error message In log files. “Unable to find appropriate service endpoint information in...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published October 10, 2014
During working in SSRS reports I have to handle division by Zero error for calculating accumulated cost by dividing Amount by Quantity. This expression works for me. IIf(Sum(Fields!xyz.Value) = 0, “N/A”, Sum(Fields!abc.Value)...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports.
by alirazazaidi · Published June 23, 2014 · Last modified July 19, 2019
Drill drown reports in Dynamics Ax 2012 R3 are very Easy. For this purpose I have to create a new AOT/Static Query AOT. This query is join between CustTable and SalesTable. I want to...
Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published June 21, 2014
In Dynamics AX 2012 Reports can be called from Class, and it is import part of MVC pattern implementation for reports The report created from following link is called from controller class http://tech.alirazazaidi.com/exploring-drill-through-reports-in-dynamics-ax-2012-r3/ Create...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports.
by alirazazaidi · Published June 19, 2014
Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity. In...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published June 13, 2014
Today while deploying Dynamics AX 2012 R3 SSRS reports on window 7 I got following when I run Report deployment command on publish-AXReport -ReportName *. “A call to the Microsoft Dynamics AX SRSFramework Service...
Dynamics AX 2012 / Dynamics Ax 2012 Reporting SSRS Reports. / Dynamics Ax 2012 Technical Side
by alirazazaidi · Published May 25, 2014
While configuring Reporting server with Dynamics Ax 2012 R23, I got error that Dynamics Ax 2012 R3 did not validate the Reporting Server. On Opening reporting server in Browser I got following error. “User...
Follow:
More