locked
expressions in SSRS RRS feed

  • Question

  • Experts,

    I have two datasets in SSRS. There is a column in each of the two datasets where I want to get the sum of this column in each sets to be obtained and again the two sums be summed up again.

    So, like SUM(sum(column), Dataset1)   +  sum(column), Dataset2)) ...... I want to keep the resulting value in a cell.

    Cheers


    ebro

    • Moved by Olaf HelperMVP Thursday, June 19, 2014 10:57 AM Moved from "SQL Database Engine" to the correct forum
    Monday, June 9, 2014 6:47 PM

Answers

  • Hi ebrolove,

    According to your description, you want to get a sum value of a column from two datasets and sum these two values into a cell. Right?

    In Reporting Services, when we use aggregation functions, we can specify the scope in the function, the scope should be group or dataset. So in this scenario, we just need to specify the dataset as scope in each sum function. Put the expression below into the textbox:
    =sum(Fields!column.Value,"DataSet1")+sum(Fields!column.Value,"DataSet2")

    Reference:
    Sum Function (Report Builder and SSRS)

    If you have any question, please feel free to ask.

    Best Regards,
    Simon Hou

    • Proposed as answer by Uri DimantMVP Tuesday, June 10, 2014 10:33 AM
    • Marked as answer by Olaf HelperMVP Thursday, June 19, 2014 10:56 AM
    Tuesday, June 10, 2014 9:12 AM