How to alternate row color based up the actual data? RRS feed

  • Question

  • I've got a simple table showing information about product category and sub categories. I would like the row coloring to alternate, with each change in the *category*. Not based on row number.

    How can I do this?

    Wednesday, November 7, 2012 5:51 PM


  • Is the table sorted by Category? Is it grouped by Category?

    If it is Grouped on Categoryor just sorted on Category, you can use: IIf(RunningValue(Fields!Category.Value,CountDistinct, Nothing) MOD 2 = 1, "Gainsboro", "White")

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

    • Proposed as answer by Charlie Liao Thursday, November 8, 2012 1:17 AM
    • Marked as answer by Charlie Liao Thursday, November 15, 2012 9:16 AM
    Wednesday, November 7, 2012 8:51 PM

All replies