Turns out someone had previously been fiddling with the Rsreportserver.config and a rogue line was breaking it.

All solved now - thanks.

Don't totally understand your question but your probably looking for the switch statement in an expression in the required area. Basic example below:

=Switch

(

Fields!YourField.Value < 8, "Green"

,Fields!YourField.Value > 8, "Red"

)

select @@VERSION

then build some case or if logic around the result.

If you look at your First_Month set which the final select statement selects from you have

WHERE ROW = 1

Its a little unclear what is actually being returned but is...

Yeah think Seans got what you need there.

Just to explain why previously it ignored the date condition

your initial statement says return everything where

b.field2 BETWEEN GETDATE() - 30 AND...

quickly tested if you have parameter set up this should work 😀 with Department being whatever you called the department parameter on the report.

="Trend For Departments " & ...

I presume you already have a parameter set up to distinguish all the individual Department Codes

try using Parameters! instead of Fields! and specify which parameter you would like to take...

If I've understood correctly you just need to amend the select list for those two columns:

ACTLABCOST = case when ACTLABCOST = 0.00 then .00 else ACTLABCOST end,

ACTMATCOST = case...