Saturday, March 1, 2014

How to do cumulative substraction in SSRS 2005 matrix report ?

FOr that you can just give expression as below inside your matrix data region



=COUNT(IIF(Fields!completion date.value<=<yourdatevale>, Fields!YourOrderField.value,Nothing),"columngroupname")-COUNT(Fields!YourOrderField.value)





Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c



No comments:

Post a Comment