web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

SSRS for Dynamics Ax 2012, group sum based on condition

Ali Zaidi Profile Picture Ali Zaidi 4,657

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 link:

http://www.sqlservercentral.com/Forums/Topic1174757-150-1.aspx

Comments

*This post is locked for comments