String matching for data in grid [message #881495] |
Mon, 04 June 2012 17:15 |
|
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 15:07 |
|
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.
|
|
|
Re: String matching for data in grid [message #881980 is a reply to message #881495] |
Tue, 05 June 2012 15:07 |
|
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.
|
|
|
|
Powered by
FUDForum. Page generated in 0.02577 seconds