Doing conditional formatting on empty cells.

Question

I'm currently building a matrix style report.

After each rowgroup, i would like to add in a nice 2pt solid black border. Unfortunately not all fields in the matrix will have data in them, and therefore i don't seem to be able to use conditional formatting on the cell level.

I've tried using IIF(RowNumber("group") = 1, "Black", "Light Gray") For the top border, but it doesn't seem to get the answer right all the time.

I tried to put RowNumber("group") into a visible field, which both caused the fields that should be empty to fill with copies from other cells and showed RowNumber to be changing in the middle of a row (it was shown for each column group), on several occasions.

Anyone got an idea as to what i can do as an alternative?

Answer 1

Random thought: Can you put a   in empty cells to force contents using IIF to test for empty/null/nothing)?

Edit: OK, next guess...

Add a dummy hidden column that deals with the rownumbering you need?