Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » String matching for data in grid(Using BIRT eclipse plug-in designer)
String matching for data in grid [message #881495] Mon, 04 June 2012 13:15 Go to next message
Olly   is currently offline Olly
Messages: 61
Registered: June 2010
Location: Florida
Member
I'm currently designing a report with the eclipse plug-in. I have a 4x4 grid of strings that is present in each record. I want to create highlighting rules that say if the string in each position contains the character '*', or some other special character then the background color of the cell will be red. The highlight rules have BIRT functions and javascript functions and other but I don't know how to do the text matching or which function to use. Should I use like, match or what? And what function should I use. I know how to get the row data just not what BIRT function to use.
Re: String matching for data in grid [message #881976 is a reply to message #881495] Tue, 05 June 2012 11:07 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

There are a lot of ways you could do this. One way would be to use like
and put in "%*%" or use a regular expression. Look at the attached
example. It shows using the regular expression and a few other BIRT
functions. Look at the highlight rule on the product code cell.

Jason

On 6/4/2012 1:15 PM, Olly Mising name wrote:
> I'm currently designing a report with the eclipse plug-in. I have a 4x4
> grid of strings that is present in each record. I want to create
> highlighting rules that say if the string in each position contains the
> character '*', or some other special character then the background color
> of the cell will be red. The highlight rules have BIRT functions and
> javascript functions and other but I don't know how to do the text
> matching or which function to use. Should I use like, match or what? And
> what function should I use. I know how to get the row data just not what
> BIRT function to use.


Jason Weathersby

BIRT Exchange
Re: String matching for data in grid [message #881980 is a reply to message #881495] Tue, 05 June 2012 11:07 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

There are a lot of ways you could do this. One way would be to use like
and put in "%*%" or use a regular expression. Look at the attached
example. It shows using the regular expression and a few other BIRT
functions. Look at the highlight rule on the product code cell.

Jason

On 6/4/2012 1:15 PM, Olly Mising name wrote:
> I'm currently designing a report with the eclipse plug-in. I have a 4x4
> grid of strings that is present in each record. I want to create
> highlighting rules that say if the string in each position contains the
> character '*', or some other special character then the background color
> of the cell will be red. The highlight rules have BIRT functions and
> javascript functions and other but I don't know how to do the text
> matching or which function to use. Should I use like, match or what? And
> what function should I use. I know how to get the row data just not what
> BIRT function to use.


Jason Weathersby

BIRT Exchange
Re: String matching for data in grid [message #884631 is a reply to message #881980] Mon, 11 June 2012 10:16 Go to previous message
Olly   is currently offline Olly
Messages: 61
Registered: June 2010
Location: Florida
Member
That did the trick. Thank you.
Previous Topic:PHP Birt Chart Drill Down
Next Topic:org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
Goto Forum:
  


Current Time: Fri Apr 18 22:01:02 EDT 2014

Powered by FUDForum. Page generated in 0.01768 seconds