Today I'm trying to fix a report where there's a matrix with quite a lot of nested IIFs. The columns show 3 different kinds of numbers for each month of the year + a total. The footer shows the sum for each month. But the sum should be different for the numbers in January, and the third line is based on a different set of numbers.
To sort out which numbers show up where, I decided to color code the background colours, using my trusted query for matrixes with more than one subtotal:
=iif(InScope("columngroup"), iif(InScope("rowgroup"), "LightBlue", "Yellow"), iif(InScope("rowgroup"), "Green", "Red"))
When doing a preview in Visual Studio, it shows up like this:
But when I deploy to the server and look at it in Internet Explorer (both 6 and 7), it shows up like this:
Why???
Bad HTML? Weird rendering?
I've done the same for forecolour (text), and it's the same as well. The preview version shows all the different colours, but the IE only shows it in the detail cells.
I guess it must be the rendering in Internet Explorer. If I export it from IE to PDF, it shows up with background colours and fore colour.