Monday, May 18, 2015

Conditional IIF Sum in SSRS report at group level

I got a requirement where I want to show sum amount based on differnent conditions.

Simple Sum of amount can be shown with following expression;

I tried following expression to show conditional sum on a group level; It did not work :(
=Sum(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0))

I tried following expression after getting idea from this blog and it worked
=Sum(VAL(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0)))


I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...