Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
4 years ago

Trying to alternate row colors based on creating a new row number

Hello, I am trying to create a report that has alternating colors for the rows.  I can't us the record Id because the Record ID is not in sequential order when filtered (as seen below).  I have bee...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Interesting question. There may be a solution using formula queries. Can you tell me the sort on your report?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Assuming that the sort is by Date and then by Record ID# as a tie breaker, then thisw formula Numeric will give you the Row #

    var text Query = "{69.LTE.'" & [Date] & "'} AND {3.LTE.'" & [Record ID#] & "'}";
    Size(
    GetRecords($Query))

    Once you get that working, you can have a row colorization formula like 

    IF(REM([Row#],2)=0, "pink", blue")
    ​

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      BTW, the 69 in my example is the Field ID for the Date field and the 3 is the Field ID for the Record ID# field (which is always 3).

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------