I have created a SQL Server 2005 matrix with a total column.
我创建了一个带有总列的SQL Server 2005矩阵。
I want to be able to change the colors of the totals only so they stand out from the rest of the data. I can change the color of the "total" label, but not the actual data.
我希望能够仅改变总数的颜色,以便从其他数据中脱颖而出。我可以更改“总”标签的颜色,但不能更改实际数据。
Can anyone give me a clue of how to do this?
任何人都可以给我一个如何做到这一点的线索?
3 个解决方案
#1
To test whether or not a cell is a total or not, you need to use the InScope() Function along with a heavily nested If statement. Jorg Klein does a great job of exlplaing how this works within a matrix (here)
要测试单元格是否为total,您需要使用InScope()函数以及重度嵌套的If语句。 Jorg Klein在矩阵(这里)中如何工作方面做得非常出色
#2
Select the Total box and you can set the color in the properties page. If you want all totals to appear in the same color, this will do.
选择“总计”框,您可以在属性页面中设置颜色。如果您希望所有总计以相同的颜色显示,则可以这样做。
You can also conditionally format them, by putting an expression in the color property.
您还可以通过在color属性中放置表达式来有条件地格式化它们。
Check this link
检查此链接
Raj
#3
Unless I'm mistaken, you can select the totals cell for editing it's properties by selecting the cell and then clicking on the small triangle in the upper corner of the cell.
除非我弄错了,你可以通过选择单元格然后单击单元格上角的小三角形来选择总计单元格来编辑它的属性。
Hope this helps,
希望这可以帮助,
Bill
#1
To test whether or not a cell is a total or not, you need to use the InScope() Function along with a heavily nested If statement. Jorg Klein does a great job of exlplaing how this works within a matrix (here)
要测试单元格是否为total,您需要使用InScope()函数以及重度嵌套的If语句。 Jorg Klein在矩阵(这里)中如何工作方面做得非常出色
#2
Select the Total box and you can set the color in the properties page. If you want all totals to appear in the same color, this will do.
选择“总计”框,您可以在属性页面中设置颜色。如果您希望所有总计以相同的颜色显示,则可以这样做。
You can also conditionally format them, by putting an expression in the color property.
您还可以通过在color属性中放置表达式来有条件地格式化它们。
Check this link
检查此链接
Raj
#3
Unless I'm mistaken, you can select the totals cell for editing it's properties by selecting the cell and then clicking on the small triangle in the upper corner of the cell.
除非我弄错了,你可以通过选择单元格然后单击单元格上角的小三角形来选择总计单元格来编辑它的属性。
Hope this helps,
希望这可以帮助,
Bill