IF statement to exclude table rows [message #492579] |
Tue, 20 October 2009 19:48 |
Owen Messages: 1 Registered: October 2009 |
Junior Member |
|
|
First off, very new to BIRT so there might be an easy solutuon to his, but I have searched multiple places but have not been able to find out what I need to accomplish.
Here is what I am trying to accomplish using the basic report in Report Design for Rational Software Architect. In my report, I want it to exclude a row in the step for certain type of messages. For example, all "100 Trying" messages. I found that BIRT can use javascript, so I thought great, I can do it through there. I just want that row omitted when the condition is met.
I figured I would need to do something of the following:
IF (messageName != "100 Trying") {
Then output row...
}
But I am not sure of the syntax of where I should be putting the IF statement. What is the best way to achieve my goal? Do I select the row, go into the script mode and use onPrepare or OnCreate? Any help or pointers to documentation/examples that cover this would be great. Can this even be accomplished?
Thanks,
O
[Updated on: Tue, 20 October 2009 19:48] Report message to a moderator
|
|
|
Re: IF statement to exclude table rows [message #492580 is a reply to message #492579] |
Tue, 20 October 2009 20:24 |
|
Owen,
Select the table and in the property editor you will see a filters tab.
Select it and add a filter. Select your column then Not Equal to, and
finally "100 Trying".
Jason
Owen wrote:
> First off, very new to BIRT so there might be an easy solutuon to his,
> but I have searched multiple places but have not been able to find out
> what I need to accomplish.
> Here is what I am trying to accomplish using the basic report in Report
> Design for Rational Software Architect. In my report, I want it to
> exclude a row in the step for certain type of messages. For example,
> all "100 Trying" messages. I found that BIRT can use javascript, so I
> thought great, I can do it through there. In the attached picture, I
> just want that row omitted when the condition is met.
> I figured I would need to do something of the following:
>
> IF (messageName != "100 Trying") {
> Then output row...
> }
>
> But I am not sure of the syntax of where I should be putting the IF
> statement. What is the best way to achieve my goal? Do I select the row,
> go into the script mode and use onPrepare or OnCreate? Any help or
> pointers to documentation/examples that cover this would be great. Can
> this even be accomplished?
>
> Thanks,
>
> O
>
|
|
|
Powered by
FUDForum. Page generated in 2.36209 seconds