Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

using data from two data sets in a matrix?? Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 1:49 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 7:34 AM
Points: 299, Visits: 498
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
Post #1434012
Posted Thursday, March 21, 2013 2:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 7:34 AM
Points: 299, Visits: 498
Sorry.. I had 1july and should have been 1July, didn't know it was case sensitive
Post #1434031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse