Post reply

Excel SumIf in SSRS

  • February 24, 2011 at 4:44 pm

    #246116

    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

  • February 25, 2011 at 8:44 am

    #1291576

    Personally I would do this as a group with totals rather than another column.

    There something called running value in SSRS expressions you might be able to use, although if I had to do it as a column I would probably build it into the dataset query rather than build it in the report itself.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply