in screenshot-Using columnD as parent group.ColumnB its child. and main parent group is columnC just for page break.
columnA is column group and using columnA and columnA for data.
i want to color the column groups in matrix only if the value is present else not. Also i want to do alternate column group colors and not show the value in the output matrix.
attached file for example.
I could get the alternate colors to show up but not able to hide the values and show the colors only if the value is present.Using below code-
Dim iCounter as Integer=0
Public Function getColumnCounter() as Integer
=iif(Code.getColumnCounter mod 2 =0 and Fields!clientName.Value>0,"LightGreen","PaleTurquoise")