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 Services. Happy Daxing.
Dynamics Ax 2012 Reporting SSRS Reports.
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 some kind of percentage calculation with ‘%’. A For this I have to use CStr ssrs expression function like Ctr(((sum(DataSet!field.Value) […]
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 requirement is that customer with certain sub classification will skip in group sum. For example those customer who are on hold […]
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 given period of time. Serial number on detail level can be achieved by RowNumber(“Scope Name”) But serial number shown on Group […]
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 link to build this functionality. https://technet.microsoft.com/en-us/library/cc582049.aspx https://dynamicsaxinsight.wordpress.com/2014/12/23/ax-2012-ssrs-report-drill-through-action-url/ to complete the re If you read the Microsoft link on TechNet in one […]
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 was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs’. The deserializer has no knowledge of any […]
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 shows following error. RegisterOverrideMethod was called twice for the same object for method ‘textChange’. You can only override a method […]
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 report body. Water mark image should be small in size and used as background Image. If you use high in size […]
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 in AOS server I have to face two issues. “No Such Host is known.” Whenever we run the report on staging […]
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 show’s primary position and department. HCMWorker table has two display method returns these values. We can add these display methods into […]