LOL! Yes, it's a matrix. I think I might have to give up on this, and just pivot the data in T-SQL and then just use a table...

Apologies for giving false hope, just did more checking, and the part of the expression that tests for the first column isn't working. Well, it does, but only if there...

I understand now (didn't appreciate that FIRST in SSRS is something completely different to First in T-SQL!).

As my first column will always be yesterday's date, I don't need the extra...

No difference between the date columns. Its just that color coding is only wanted on the most recent day, i.e. the first column.

I'm not sure your expression would work...

Doh! It is now.

Hi,

You're right, a picture is worth a 1000 words so hopefully the attached will help.

Barry

Apologies, there's an extra element to the expression:

=IIf(ColumnPosition=1,IIf(Fields!FieldName.Value=0,"Red","Green"),Nothing)

In other words, if it's column 1, and if the value = 0 then red, else green - if it's any other column,...

The first column of the Column Group grouping, e.g. if I had person as the row group, sales date as the column group, and number of orders as the sum,...

Hi Grasshopper,

I did look at that first, but I couldn't access the System variable "ErrorDescription" (which I wanted to include in an email). So in the end I used...

Apologies Brian, please ignore my previous post. I was able to carry out your procedure using the domain admin account.

It failed the first time because I hadn't closed ALL...

Hi Brian,

How do I get your solution to work on a server that is the DC?!

I'm running SQL Server 2008 on Windows Server 2008, and this server is the AD...

Mark, that's brilliant!! And what a quick response.

Many thanks, you are a life saver!

Barry

Good point about the name.

Thanks for your comments Denis.

Regards,

Barry

Hi Denis,

I had thought of the approach you suggested, but something knaws at me that...

Hi Aaron,

I checked out your article and noted that someone from the SQL Server team said this would be fixed in SP1.  We're now on SP2!  Have they said when...