Discussions

Expand all | Collapse all

Coloring alternate row

  • 1.  Coloring alternate row

    Posted 12-21-2016 03:15
    Is there a native way to colour each alternate row in a timeline report? 


  • 2.  RE: Coloring alternate row

    Posted 03-16-2017 06:05
    Natively and Perfectly, no.

    But here is a sneaky workaround for another option.

    If(Rem([Record ID#], 2)=0, "#EvenColor", "#OddColor")

    This will basically will devide the record id by 2 and if there is no remainder, then it will color one, or the odd color.

    It works as long as you have one of the sorting things to go by record ID, first or last.

    Or if you have some field that sequentially grows you can use that as well.

    Just Ideas.


  • 3.  RE: Coloring alternate row

    Posted 03-16-2017 16:13
    Great! Love your skills Buddy :) :)


  • 4.  RE: Coloring alternate row

    Posted 03-16-2017 21:16
    Matthew - this is brilliant in its simplicity. Love it. =]


  • 5.  RE: Coloring alternate row

    Posted 04-04-2017 07:42
    Hi there, 2 questions - can you colour rows dependent on the resource (assigned to) using a variation of the above? Secondly, where do you put the code??


  • 6.  RE: Coloring alternate row

    Posted 04-04-2017 07:59
    Hi Peter,

    Just customise the report and put the code in the row colorization under the Record highlight option.

    Please let me know if you need any further help.

    Thanks,
    Gaurav 


  • 7.  RE: Coloring alternate row

    Posted 04-04-2017 08:12
    Thanks - any clue on how to code a colour change for each different assigned to record?


  • 8.  RE: Coloring alternate row

    Posted 04-04-2017 09:11
    also - seems no area for coloration on timeline report :-(


  • 9.  RE: Coloring alternate row

    Posted 04-04-2017 14:17
    If your "assigned to" resource is via a relationship,...

    Create a new field on the resource table, call it something like [Color]
    Put the custom color hex (#xxxxxx) there, then pass that value to the main table (tasks or jobs, whatever you have it called).

    Then in the report settings you can select the checkbox for 'colorization' towards the bottom, the simply insert that new lookup field [Resource - Color]


  • 10.  RE: Coloring alternate row

    Posted 04-04-2017 14:19
    Actually, peter is using timeline report and there is no option for colorization. :)