Skip to main content



      Home
Home » Archived » 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
Eclipse UserFriend
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
Eclipse UserFriend
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 11:07 Go to previous messageGo to next message
Eclipse UserFriend
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 #884631 is a reply to message #881980] Mon, 11 June 2012 10:16 Go to previous message
Eclipse UserFriend
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 Jul 04 18:17:28 EDT 2025

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

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

Back to the top