Post reply

using data from two data sets in a matrix??

  • March 21, 2013 at 1:49 pm

    #275418

    Hi

    Fairly new to SSRS...

    I'm trying to do =iif(Fields!month.Value="1july",Sum(Fields!Julschedhours.Value, "DataSet2"),"g")

    Which is in a matrix for months 1-12

    SO if the field month = 1july then I want the value of the sum(Julschedhours), then I was going to string along the same for each month

    but when I run it I excepted g's in each month excepy July, but july has a g too?

    Thanks In advance

    Joe

  • March 21, 2013 at 2:40 pm

    #1599586

    Sorry.. I had 1july and should have been 1July, didn't know it was case sensitive

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

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