Forum Discussion

8 Replies

    • JessicaHaskins's avatar
      JessicaHaskins
      Qrew Cadet
      Oops sorry I realized I just renamed the record ID. I tried the formula, but it doesn't display correctly, because the report is filtered based on a condition. So it shows up like this
  • Thanks Jim, but I deleted my record ID # field, so I can't use the formula 

    If(Rem([Record ID#], 2)=0, "#EvenColor", "#OddColor")
  • Every table needs a Record ID# field.  You have probably just renamed it to something else.

    Look at your list of fields in the table, and you'll see one field with the gold key icon.  You can use that field name instead of Record ID#

  • GaryBoyd's avatar
    GaryBoyd
    Qrew Assistant Captain
    I would also like to know the answer to this. Running formulas to display selected records, so odds/ evens color solution will not work. Thanks.
  • There are class "od" and "ev"  on the odd and even rows of a table report  you can use for selectors.
    Using IOL on the report you can set even rows to have a gray background with code similar to this:

    $("table.searchResults tr.ev").css({backgroundColor: "#f2f2f2"});

  • GaryBoyd's avatar
    GaryBoyd
    Qrew Assistant Captain
    Thanks - using your techniques of oil and bol seems to open up a lot of options.