在ssrs中矩阵图表的隔行变色

在ssrs里，如果图表不是很大，而且它要求在每个栏目下有总计，总计的行是别的颜色。这就要求我们

第一，新建计算成员，

第二，将建好的计算成员进行排序

第三，排序后对计算成员进行添加颜色：

代码如下：

背景色

 

=iif(Fields!Brand.Value= "DG1","#ccffff", iif(

      Fields!Brand.Value = "DL1","#ccffff",iif(

  Fields!Brand.Value = "DG2","#ccffff",iif(

  Fields!Brand.Value = "DG3" ,"#ccffff",iif(

  Fields!Brand.Value = "DG4" ,  "#ccffff",iif(

  Fields!Brand.Value = "DA 3","#ccffff",iif(

  Fields!Brand.Value = "DA4","#ccffff",iif(

  Fields!Brand.Value = "DMP","#ccffff",iif(

  Fields!Brand.Value = "Specialty" ,"#ccffff",iif(

  Fields!Brand.Value = "Imported SEN", "#ccffff",iif(

  Fields!Brand.Value = "BB 3" ,"#ccffff",iif(

  Fields!Brand.Value = "DIF" ,"#ccffff",iif(

  Fields!Brand.Value = "DFO" ,"#ccffff",iif(

  Fields!Brand.Value = "D1P" ,"#ccffff",iif(

  Fields!Brand.Value = "D3P" ,"#ccffff", "No Color")))))))))))))))