Wednesday, 18 September 2013

Display Alternative Colors to Alter native Rows




Select the Row with particular no of fields --> Select Text box Props--> Fill--> Fill Color : fx
Set Expression for Background Color :

For 2 Colors:
IIF(RowNumber(Nothing) MOD 2, "lightGreen", "LightRed")

For 3 Colors:
=SWITCH(RowNumber(Nothing) MOD  3=0,"Red",
                   RowNumber(Nothing) MOD  3=1, "Green",
                   RowNumber(Nothing) MOD  3=2, "Yellow"
                )

No comments:

Post a Comment