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) / … [Read more...] about float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.
Dynamics Ax 2012 Reporting SSRS Reports.
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 or blocked will not shown in report group sum, but shown in report … [Read more...] about Skip certain values Report group sum SSRS Dynamics Ax 2012 R3. Dynamics 365 for operations
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 level is tricky because RowNumber not works there. … [Read more...] about Serial Number in Report Group SSRS Dynamics Ax 2012 R3.
Today is another small tip, I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On mapping the transtime to report, its showed time format. Instead of time value. For it solution, I added the string field on report temp table and then convert the time with time2str function and map to the … [Read more...] about Time field on SSRS shows time format Report Dynamics Ax 2012
Interesting, I was modifying some RDP based report, I found that parameter was passed to report through custom table, As report will run form button, and based on current selected record. So former developer did that on pressing button, selected value inserted some custom table. When report run, query on table and fetch required value form custom table and whole report logic … [Read more...] about How to run RDP based report from X++ and passing parameter using Data contract.
Consider a scenario that we are listing sale line for customers on RDP based report. Data is huge on server and report time out occur. In Dynamics Ax 2012 R3 provide new class “SrsReportDataProviderPreProcessTempDB” use this class instead of SRSReportDataProviderBase For base for this report we please follow below … [Read more...] about How to handle long running reports in Dynamics Ax 2012 R3
RDP or Business logic based SSRS Reports in Dynamics Ax 2012 R3. Logic based report in MS Dynamics Ax 2012 can be develop in following steps Create a temporary table Define the report parameters Add business logic for the report Create a reporting project Bind a report to a report data provider class In graphical shape RDP reports … [Read more...] about RDP or Business logic based SSRS Reports in Dynamics Ax 2012 R3.
During SSRS report for Dynamics Ax 2012, I found that when report goes on multiple pages, column header did not appear all page except the first one. I fix this problem by setting some properties to true. Select the tablix and below right side of columns group header and click there on small arrow head and select the advance Mode. This will open … [Read more...] about Repeat the column header row on every page Tablix SSRS dynamics Ax 2012
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) / IIf(Sum(Fields!abc.Value) = 0, 1,Sum(Fields!xvz.Value))) I did little research on Expressions and function used in these … [Read more...] about List of functions used in Dynamics AX 2012 SSRS Reports Expressions
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 create Inner Join so Only those Customer came who have Sales Orders. Consider following Steps to create A new report Create a new Query with Name “DyWorldCustSales” Drop or add Data Source with … [Read more...] about Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3.
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 a new class and extends it with “SRSReportRunController” class. Add New method, and update it … [Read more...] about Exploring Report Controller class in dynamics AX 2012 R3
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 this report when User click on customer account, a new report open which contains list of all possible sales Order. For this Purpose I created two Static/AOT queries. First … [Read more...] about Exploring Drill through Reports in Dynamics Ax 2012 R3.
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 service failed. An existing connection was forcibly closed by the remote host.“. I perform following steps to solve this problem. 1. Stop reporting … [Read more...] about A call to the Microsoft Dynamics AX SRSFramework Service failed.
When you install dynamics Ax 2012, default reports automatically deployed. But sometimes we have to deployed the reports manually. Dynamics Ax provides build in PowerShell commands to perform various operations. For testing these commands, you have to run Power shell Management Shell as Administrator. $reports = Get-AXReport -ReportName * $reports Above … [Read more...] about Power script commands and Dynamics Ax 2012 SSRS reports.
I got task to extend the existing dynamics ax SSRS report. Client also wants to sustain the existing report. They want a new report that will be replicate the original one with extended features. Data provider classes are easily duplicated by right clicking on it and select duplicate, I renamed the duplicate classes in AOT. Initially I did not change anything in renamed classes … [Read more...] about Dynamics Ax 2012: How to duplicate the existing report for modification