I needed to display some reports with alternating colors for columns today. The report was a matrix report that had a column group that showed the months of the year.
After selecting the column go to properties and click on Fill -> Background color -> Expression
In the expression box type the following:
=iif(Fields!MonthNumber.Value mod 2,"Transparent","LightGrey")
The same thing can be achieved for the rows. Instead of selecting the column, select the row of the table and follow the same steps.
Hope it will be usefull!
No comments:
Post a Comment