Post reply

Alternating background color in a Matrix

  • August 22, 2006 at 2:04 pm

    #170084

    I tried

    = iif (RowNumber (nothing) Mod 2, "Lightgrey", "transparent")

     

    but the resulto was weird. It was not alternating correctly.

    In the columns group i could not use

    = iif (RowNumber (nothing) Mod 2, "Lightgrey", "transparent")

    this error occurred

    The background color expression for the textbox ‘delta_odometro’ has a scope parameter that is not valid for RunningValue, RowNumber or Previous. The scope parameter must be set to a string constant that is equal to the name of a containing group within the matrix ‘matrix1’.

    Build complete -- 1 errors, 0 warnings

    Someone could help?

  • August 23, 2006 at 6:43 am

    #656333

    I'm probably out of my depth here.....but as in crystal reports is there not a function that will allow you to do this depending on the remainder left when you divide the row number by 2

    if Rem(row Number/2)>0 then LightGrey Else Transparent

    This is NOT the correct syntax, but I was just reading this over lunch...........

  • August 23, 2006 at 8:50 am

    #656380

    Try this:

    =IIf(RowNumber("table2") Mod 2, "White","Gainsboro")

  • August 23, 2006 at 9:40 am

    #656403

    Luiz,

    RowNumber function doesn't work with matrices because it returns row number in dataset, not in matrix.

    Here's what I did to alternate colors in matrix rows.

    1. I've created a function

      Public BackColor As String = "White"

      Public Function GetBackColor() As String

       If BackColor = "White" Then

        BackColor = "Gainsboro"

       Else

        BackColor = "White"

       End If

       Return BackColor

      End Function

    2. In the column header BackgroundColor Property I put the following expression:

      =Code.GetBackColor()

    3. In the matrix cell BackgroundColor Property I put the following expression:

      =Code.BackColor

    It worked for me. Try it

  • August 23, 2006 at 11:27 am

    #656426

    Thanks Grasshopper,

    Worked fine. Helped a lot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply