Here are some details

create table employee(

EMP nvarchar (10),

STATE ...

That sounds right, what i had to do is a another dataset that gives me only the 1st one. Is there a way to right it where i don't...

I have two datasets

lets just say dataset3 and dataset4

When I run this:

=Sum(Fields!S125.Value, "DataSet4")

It gives me the sum of each employee in one total.

This is what I expect to see

employee ...

That works. Thanks

Ok, i got it to work with two conditions:

=(iif(trim(Fields!PAYROLCD.Value) like "*S401BM*", "S401BM", nothing) + iif(trim(Fields!PAYROLCD.Value) like "*S401DM*", "S401DM", nothing

but when i add the 3rd condition the 3rd one gives me...

I got it to work like this:

=iif(trim(Fields!PAYROLCD.Value) like "*S4BSC*", "S4BSC", nothing) + iif(trim(Fields!PAYROLCD.Value) like "*S401K*", "S401K", nothing)

I replaced the or with a plus sign

I can get this to work

=iif(trim(Fields!PAYROLCD.Value) like "*S4BSC*", "*S4BSC*", nothing)

but when i try to get two of them together to work i get error on both lines it should display...

I got it to work this way

=(Iif(trim(Fields!PYRLRTYP.Value) = 2 AND trim(Fields!SFRFEDTX.Value) = 0 AND TRIM(Fields!payrolcd.Value) LIKE "*[SMED]*", CDbl(Fields!UPRTRXAM.Value),CDbl(0)))

It returns zero's

I lied it didn't work

I got it. I replace the % with * and it works

This doesn't return anything when I put the like expression in it.

=sum(Iif(trim(Fields!PYRLRTYP.Value) = 2 AND trim(Fields!SFRFEDTX.Value) = 0 AND TRIM(Fields!payrolcd.Value) LIKE "SMED%", CDbl(Fields!UPRTRXAM.Value),CDbl(0)))

Is there a work around.

=sum(Iif(trim(Fields!payrolcd.Value) = "SALARY" and trim(Fields!PAYRCORD.Value) = "SALARY", cint(Fields!Untstopy.Value),0))

Ok when i put the cint in front it gives me numbers now, but it rounds them. Is there a way i...

Thanks

Duhhhhhhhhhhhh

[rsAggregateOfMixedDataTypes] The Value expression for the textrun ‘textbox35.Paragraphs[0].TextRuns[0]’ uses an aggregate function on data of varying data types. Aggregate functions other than First, Last, Previous, Count, and CountDistinct can...