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 |
|
TPie9
Yak Posting Veteran
67 Posts |
 Posted - 2009-11-13 : 09:59:43
|
| I have a matrix where the subtotal and total cell formatting works in business intelligence development studio and not on the Server after I deploy the report? Negative numbers are red and positive numbers are black like I've formatted and it works in the development environment but when I deploy the report to the server only the data cells are red for negative numbers and the subtotal and total cells are black when they should be red. Any suggestions? Thanks |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-11-13 : 10:51:49
|
| to format sub-totals/totals right click on the small green triangle and click properties and set your expressions at that place. |
 |
|
|
TPie9
Yak Posting Veteran
67 Posts |
Posted - 2009-11-13 : 11:46:51
|
| I've tried the following for the "color" in the properties area after clicking the small triangle. As previously stated the format works correctly in the development environment but it still doesn't hold the format when deploying to the server:=iif(Sum(Fields!Profit.Value, "DataSource1")<0,"Red", "Black")I also have a second column (Revenue) along with Profit and need to know how to include that column as well in the above forumula. I'm not sure if it matters, but the Revenue and Profit "color" are formatted as follows in the data area:=iif(ME.Value<0,"Red", "Black")This formatting holds true in the development environment and when the report is deployed. |
|
|
|
|
|
|
Matrix Subtotal Total Number Formatting in SSRS