locked
Getting the wrong Summed values on a MultipleDataset RRS feed

  • Question

  • User918710406 posted

    Trying to pull into a TextBox on a report a Total Sum of pages for an organization, single database but multiple Datasets in a report. This iif statement will run but sums all pages into one total for all Months need it to just get the Month in the statement for example 10th month and instead it is getting Month 1, 2, 3 etc. I have tried to add in DataSet2 after the xMonthCreated Value as this is contained in both datasets but it gives another error.

    =IIf(Fields!XMONTHCREATED.Value=10,Sum(Fields!TOTALPAGESIN.Value, "DataSet2"),Nothing)

     

     

    Any help would be appreciated, fairly new to using SSRS R3 2008. Thanks in advance.

    Inserting the value into just a flat table cell.

     

    Wednesday, November 14, 2012 4:08 PM

All replies

  • User2105670541 posted

    try below code:

    =IIf(Fields!XMONTHCREATED.Value=10,Sum(Fields!TOTALPAGESIN.Value, "DataSet2"),0)



    Monday, November 19, 2012 12:51 AM