Coloring alternate row
Is there a native way to colour each alternate row in a timeline report?
Forum Discussion
9 Replies
- 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.- Great! Love your skills Buddy :) :)
- Matthew - this is brilliant in its simplicity. Love it. =]
- 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??
- 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 - Thanks - any clue on how to code a colour change for each different assigned to record?
- also - seems no area for coloration on timeline report :-(
- 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]- Actually, peter is using timeline report and there is no option for colorization. :)
