Alfasith AX

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

Thursday, December 27, 2018

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,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...