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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 301, Visits: 500
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 301, Visits: 500
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