Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Background color on date cells(How to include background colors to cells in a table)
icon3.gif  Background color on date cells [message #1057896] Thu, 09 May 2013 11:31 Go to next message
Eclipse UserFriend
Hi-

New to Birt. trying to figure out how to include background colors in a table.

Example table:
Location UserID LName Job Cd Gen Safety
1234 1234567 Smith 0002-001 4/12/2010
1235 1234568 Smith 0001-002 5/5/2011
1236 1234569 Smith 0031-003 12/10/2011
1237 1234561 Smith 0033-001 6/10/2012

The Gen Safety field/column is a date field

Tried using this in the Expression Builder under Properties/Visibility(tab) hitting the function button:

IIF(BirtDateTime.diffDay("GEN_SAFETY", BirtDateTime.now()) >760, RGB(0,0,255))

Here's logic behind Gen Safety's dates:
If > 760 days from today , background color is BLUE
if > 730 days from today , background color is RED
if > 640 days from today, background color is YELLOW
Else (or less than 640 days), background color is GREEN
****see attched table sample*****

It does not work. Any solutions w/b appreciated.
Re: Background color on date cells [message #1057914 is a reply to message #1057896] Thu, 09 May 2013 14:28 Go to previous messageGo to next message
Eclipse UserFriend
Instead of using visibility, have you tried using the highlight feature in the property editor for the date field? You can create expressions for when to highlight.
Re: Background color on date cells [message #1058010 is a reply to message #1057914] Fri, 10 May 2013 09:28 Go to previous messageGo to next message
Eclipse UserFriend
Highlight works with conditions when using exact dates with Between. How could I use a condition as stated above...from today's date back 760 days, if >760 then highlight blue?
Re: Background color on date cells [message #1058011 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058013 is a reply to message #1057914] Fri, 10 May 2013 09:28 Go to previous messageGo to next message
Eclipse UserFriend
Highlight works with conditions when using exact dates with Between. How could I use a condition as stated above...from today's date back 760 days, if >760 then highlight blue?
Re: Background color on date cells [message #1058015 is a reply to message #1057914] Fri, 10 May 2013 09:28 Go to previous messageGo to next message
Eclipse UserFriend
Highlight works with conditions when using exact dates with Between. How could I use a condition as stated above...from today's date back 760 days, if >760 then highlight blue?
Re: Background color on date cells [message #1058016 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058019 is a reply to message #1057914] Fri, 10 May 2013 09:28 Go to previous messageGo to next message
Eclipse UserFriend
Highlight works with conditions when using exact dates with Between. How could I use a condition as stated above...from today's date back 760 days, if >760 then highlight blue?
Re: Background color on date cells [message #1058020 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058023 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058027 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058030 is a reply to message #1057914] Fri, 10 May 2013 09:31 Go to previous messageGo to next message
Eclipse UserFriend
Highlight with condition works with exact dates, but what about form today back 760 days?

if date is >760 days from today, highlight BLUE
Re: Background color on date cells [message #1058038 is a reply to message #1058011] Fri, 10 May 2013 11:04 Go to previous messageGo to next message
Eclipse UserFriend
You should be able to do > 760 days by using the expression builder. You can use the date in the date column, today's date, and a BIRTDateTime diff function.

Something like:
BirtDateTime.diffDay(row["dateField"],new Date());
Re: Background color on date cells [message #1058068 is a reply to message #1058038] Fri, 10 May 2013 14:53 Go to previous messageGo to next message
Eclipse UserFriend
THANK YOU.
Razz
That works.

760 less than or equal to BirtDateTime.diffDay(row["GEN_SAFETY"],BirtDateTime.today())

Have a nice weekend! Razz
Re: Background color on date cells [message #1058172 is a reply to message #1058068] Sun, 12 May 2013 23:38 Go to previous messageGo to next message
Eclipse UserFriend
Great! Glad I could help. Hope you had a great weekend!
Re: Background color on date cells [message #1058361 is a reply to message #1058172] Mon, 13 May 2013 13:12 Go to previous messageGo to next message
Eclipse UserFriend
Any suggestions on how to NOT highlight a null value?

Using 4 different conditions listed above, and they work, but now trying to keep UN highlighted format for those columns with Null vales.
Re: Background color on date cells [message #1058424 is a reply to message #1058361] Tue, 14 May 2013 01:17 Go to previous messageGo to next message
Eclipse UserFriend
Have you tried adding && row["myField"] != null to your conditions?
Re: Background color on date cells [message #1058897 is a reply to message #1058424] Wed, 15 May 2013 11:10 Go to previous messageGo to next message
Eclipse UserFriend
Tried that, but can't seem to get the condition to work.

760 less than or equal to BirtDateTime.diffDay(row["GEN_SAFETY"],BirtDateTime.today())

Current condition above works to highlight in BLUE, but still need help with how to adress NULL values in the condition.
Re: Background color on date cells [message #1058965 is a reply to message #1058897] Thu, 16 May 2013 00:39 Go to previous message
Eclipse UserFriend
Try something like:

if(row["GEN_SAFETY"] != null){
   if(BirtDateTime.diffDay(row["GEN_SAFETY"],BirtDateTime.today()) > 760){
      true;
   }
   else{
      false;
   }
}
else{
   false;
}

is True
Previous Topic:BIRT in eclipse
Next Topic:Report Date and Timestamp Converstion
Goto Forum:
  


Current Time: Sat May 17 18:29:04 EDT 2025

Powered by FUDForum. Page generated in 0.05118 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly