Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Excel SumIf in SSRS

Author  Topic  ksm2004 Starting Member 1 Post Posted - 2011-02-24 : 18:42:46 Hi I'm trying to convert Excel report to Reporting services 2008. The problem is SUMIF in excel running accross the entire column. I have: col A - Order# col B - Customer# col C - OrderAmount I need: col D - Sum of all customer orders for report period. In Excel it was done by =SUMIF(B:B,B1,C:C) Is it possible to replicate it in SSRS? Regards Kirill