Changing colors on grouped lines:
Group lines according to Account value and change the color for the entire group.
=IIF(RunningValue(Fields!Account.Value, CountDistinct, Nothing) MOD 2 = 1, "WhiteSmoke", "White")
Border style on groupings:
Top: =IIF(Fields!Account.Value = Previous(Fields!Account.Value), "None", "Solid")
- So, when Account value changes, top line becomes gets a solid border style.
Bottom: =IIF(RowNumber("AccountLines_DS") = CountRows("AccountLines_DS"), "Solid", "None")
- When we reach the last line, draw a solid border.
No grouping at all:
= IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
And something ..more like a personal note.
=FORMAT(Fields!TransDate.Value, "dd.MM.yyyy")
