Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Thursday, December 27, 2018

New line / Line break in expression of SSRS

Hi,

=First(Fields!CompanyAddress.Value, "EcomPackingSlipTmp") & vbcrlf &
First(Fields!CompanyURL.Value, "EcomPackingSlipTmp") & vbcrlf &
First(Fields!CompanyPhone.Value, "EcomPackingSlipTmp")

Regards,

Make a group by in SSRS

Hi,

Sample, here I have Amount values that is sum(Amount) all the sales Order, but I need the group by Sales Id.

below expresion works for me when I add this filed group by in that particular tablix.

=Sum(CDbl(Fields!Amount.Value))

Regards,

How find size of recordsortedlist in D365/AX 2012

Hi, This is the continuity of the previous article where we are now getting the size of recordsortedlist . if(recordsortedlist.len() >1) ...