Highlighting columns

Hi all,

I have a set of columns displaying months of the year and want them to be highlighted yellow every quarter. I am using the highlight function in BIRT properties to achieve this, but was wondering if theres a way to apply this to all quarters regardless of what year it is?

Currently im using:
data[REPORTING_DATE"] Equal to "2008-03-31 00:00:00.000"
data[REPORTING_DATE"] Equal to "2008-06-30 00:00:00.000"
data[REPORTING_DATE"] Equal to "2008-09-30 00:00:00.000"
data[REPORTING_DATE"] Equal to "2008-12-31 00:00:00.000"

So above only works for 2008... I want this to last from 2008 - end of the world...

Any ideas?

Thanks!

Find more posts tagged with

Comments

mwilliams

Hi richpoulse,

If I'm understanding correctly, you could just pull the month value from the date and check for that, rather than the entire date.

richpoulse

Hi Michael,

Thanks for your reply.

I have tried what you said but without any luck. It seems that BIRT only recognizes the command when its typed out in full:

eg - data[REPORTING_DATE"] Equal to "2008-03-31 00:00:00.000"

Obviously a work around to this would be to use the same statement for the next 10 years, however as I have A LOT of cross tabs this could take the next 10 years to do.

Anything else you could suggest?

Thanks...

richpoulse

Hi,

I finally figured out how to get it to work!

I used the following statement:

data[REPORTING_DATE"] Like "%Mar%"
data[REPORTING_DATE"] Like "%Jun%"
data[REPORTING_DATE"] Like "%Sep%"
data[REPORTING_DATE"] Like "%Dec%"

Just incase anyone else ever encounters the same problem as I did

mwilliams

richpoulse,

Glad to hear you got it working. Let us know if you have any other questions.