Forum Discussion

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

Qrew Legend

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

Qrew 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
Qrew 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
------------------------------