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 |
|
gcowhsu
Starting Member
38 Posts |
 Posted - 2005-06-30 : 14:38:29
|
| I have a really long report, width, and if you are scrolling you lose track where the subtotals are so I want to change the background color of them. However, it is not that easy with RS. I was thinking about putting an expression in the background color for the textbox that is being subtotaled that would checkIf subtotal then background color = blue else white.Is this possible?Michael Hsu |
|
|
jhermiz
3564 Posts |
Posted - 2005-06-30 : 14:46:18
|
quote:
Originally posted by gcowhsu
I have a really long report, width, and if you are scrolling you lose track where the subtotals are so I want to change the background color of them. However, it is not that easy with RS. I was thinking about putting an expression in the background color for the textbox that is being subtotaled that would checkIf subtotal then background color = blue else white.Is this possible?Michael Hsu
Are your subtotals in some sort of footer or in the details section of the matrix report. If the former simply set the focus on the subtotal field and change the color from the properties section.The property is BackgroundColor (me thinks)Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-06-30 : 15:04:06
|
| Matrixes do not have footers. I just left clicked on the group and hit subtotals and then SSRS puts in that extra row that says totals. |
|
|
|
mahfoozelahi
Starting Member
5 Posts |
Posted - 2005-06-30 : 15:14:28
|
| In the backgroundColor property of the field, you can write something like this =iif(Fields!RFPC_Status.value ="DONE" , "Palegreen", "White")where first part is a condition, 2nd part is the bgcolor when it is true and 3rd part is when it is flase.Good luck!Mahfooz |
|
|
|
|
|
|
Need help with Matrix Subtotals