SUM VALUES BASED ON IIF CONDITION in RDLC REPORT

Step 1: Open Business Intelligence Development Studio (BIDS) (Start --> Microsoft SQL server 2008 --> SQL server Business Intelligence studio



Step 2: Click File --> New project --> Report Server Project Wizard. Give any name and location. -> OK.

Step 3 : Click Next. Now configure your connection string. I have chosen the type as 'Microsoft SQL server'

Step 4 : In this step, you need to enter the query that I heve mentioned above for the data

Step 5 :Click Next -> Add the field ->next

You can take help from below link;

http://ift.tt/Yhkck4

http://ift.tt/1fdKz1W

---

Please Mark This As Answer or vote for Helpful Post if this helps you to solve your question/problem.