Eclipse Community Forums: BIRT » String matching for data in grid

Help

Home

Home » Eclipse Projects » BIRT » String matching for data in grid(Using BIRT eclipse plug-in designer)

Show: Today's Messages :: Show Polls :: Message Navigator

String matching for data in grid [message #881495]

Mon, 04 June 2012 13:15

Olly
Messages: 60
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.

Report message to a moderator

Re: String matching for data in grid [message #881976 is a reply to message #881495]

Tue, 05 June 2012 11:07

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.