When you say output window, you mean the window when i click preview correct?

So your telling me

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

should work?

How do i trouble shoot that error

In the column the results show

#Error

That is what i have and all the results are errors?

so how should it look

When I do it like this there are not errors in the expression window but the results are all errors

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

It tells me wrong number of arguments

Thanks, that worked

I'm getting this error on reports that do not have parameters.

The permissions granted to user 'MILKY_WAY\tharry' are insufficient for performing this operation. (rsAccessDenied)

If a report that I publish(ssrs)...

I got the results that i need

=sum(IIf(trim(Fields!sutastat.Value) = "LA", Fields!totals.Value,0))

Thanks

Thay may be the problem.

I copied it from the sql table and it looks like this:

'LA '

so how would i trim that.

I tried

=sum(IIF(trim(Fields!sutastat.Value = "LA",1,0)))

doesn't like it.

=SUM(IIF(Fields!sutastat.Value = "LA",1,0))

Returned a zero

=Count(IIf(Fields!sutastat.Value = "LA",1,0))

I only have 4 records with that status.

This still returns all rows.

When I try this:

=Count(IIf(Fields!sutastat.Value = "LA", Fields!sutastat.Value,Nothing))

I get zero

All i'm trying to do is this

select count(*) from...

Data will be put in those columns from another table later. Right now i just want the columns added and have them blank

The columns would be the results of the select statement

select * from #temptable

Name Larry Moe ...