Announcements
No record found.
Hi,
I am designing a simple report, where i want to calculate the total of a particular column(Derived from two columns of a table)....How to do that in Dynamics?
*This post is locked for comments
you can use a report control of the Sum type (for summing based on a single table field) or your own calculation logic (send() method is often good place for it).
Thanx for responding Martin,
Will you give an example...
With Regards:
Azami
For an example of using the Sum control, see the tutorial_CustomizedSumDescription report. For a custom calculation, see - let's say - CustSalesItemGroupStatistics_NA report (and calculation of totalGroupAmount) - it is (of course) only one from many possibilities how to implement it.
For completeness: the examples above exist in AX2009, they may be missing in older versions.
To diplay the total of a column (named ColumnA), you have to :
That's all, the sum of all lines will be diplayed in the field.
Remark : naturally the ColumnASum must be created outside and after the Body containing the ColumnA
Best regards,
Thanx a lot Mohammed Amine HAMDAOUI ....
I got the desired result....
I have one more problem. ie; In my report I have a column that has same value for all records...I want to display that value only once....How to do that....
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
