Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bushfoot
Yak Posting Veteran
53 Posts |
 Posted - 2009-07-21 : 13:17:48
|
| IIF(RowNumber("matrix") = Previous(RowNumber("matrix")), true, false) Is there another way to do this? I set one of my cells in the matrix to write the rownumber. The row number of the subtotal row was the same as the previous row. I want to change the color of the subtotal row so if cur = prev then its a subtotal and I can set the background color and borders. PS I tried InScope and it doesnt work either |
|
|
|
|
|
IIF(RowNumber() = Previous(RowNumber()) ..