using data from two data sets in a matrix??

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » using data from two data sets in a matrix??

using data from two data sets in a matrix??

Rate Topic

Display Mode

Topic Options

Author

Message

jbalbo

Posted Thursday, March 21, 2013 1:49 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:00 PM
Points: 152, Visits: 222

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

jbalbo

Posted Thursday, March 21, 2013 2:40 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:00 PM
Points: 152, Visits: 222

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

Post #1434031

« Prev Topic | Next Topic »

Permissions