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.
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.
Time change, Things change but experience always counts. Today I decide to write a post to build very simple custom Report Data provider based report. It is similar report I developed back in May or April 2012. My current development environment is Dynamics 365 for operations Update 2 vm on my personal Laptop vm. Prerequisite of this post is understanding the AOT in … [Read more...] about Customization in Dynamics 365 for operation (Dynamics AX, AX 7) – Part 7 Custom SSRS based on Report Data provider.
Small tip today, In one of my custom SSRS report for Dynamics Ax 2012 on group total, requires conditioning, For example sum did not include the value in the based on certain value of other field. I used following expression to solve this problem. =Sum(iif(Fields!FieldName.Value <> "abcdxyz", Fields!FieldName.Value, CDbl(0))) I took help from following … [Read more...] about SSRS for Dynamics Ax 2012, group sum based on condition