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 |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2009-12-01 : 11:45:10
|
| I'm building a report using a matrix. The matrix rows are alternating light gray and white. I would like the subtotal row and column to be a darker gray. My problem is that I can set the text boxes on the subtotal row and column to the desired color, but the rest of the row and column is still white or light gray. Even when I highlight the entire subtotal row and set the background color, only the textbox is the correct color. I'm sure I'm overlooking something simple, so please feel free to point out what I'm missing.Thanks in advance, |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-12-01 : 12:59:05
|
| Click the sub-total Textbox. In the top right should be a very small triangle. Right click and select properties. Change backgroud color there.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
stonebreaker
Yak Posting Veteran
92 Posts |
Posted - 2009-12-01 : 13:45:59
|
| Thanks, that worked. I hate it when a process is so simple they don't bother to mention it in BOL!(_8(|) |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-12-01 : 20:45:07
|
| No Worries! Trust me, I asked the same question 3 months ago because I couldn't get it to work either... Very Glad to help!JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-12-01 : 20:46:15
|
| You can also do it with the InScope function but this is WAY easier.JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|
|
setting the matrix subtotal background color