Eclipse Community Forums: BIRT

Home » Archived » BIRT » Dynamic Text(Use Logic Statements in Dynamic Text)

Sat, 13 August 2011 02:22

Eclipse User

Dear All,
I am currently looking how to use the Dynamic text control in BIRT.

I am having an issue:

I have 3 fields in my dataset: Address1, Address2, Address3

I want to display the 3 fields concatenated in a dynamic text that i set to HTML and Dynamic. The 3 addresses are then separated by a comma (","). Yet, if an address is blank (""), i dont want to show it.

So, in the edit window, i added the following code with a javascript if statement:

if(<VALUE-OF>row["Add1"]</VALUE-OF> == "")
{
"";
}
else
{
<VALUE-OF>row["Add1"]</VALUE-OF> + ",";
}

Unfortunately, it does not seem to work. Could anyone please please advise me here how to use it properly?

Thanking you in advance

Karvesh

Re: Dynamic Text [message #715296 is a reply to message #715293]

Sat, 13 August 2011 03:04

Eclipse User

Dear All,

Myself again. After some searching and struggling, the nearest I could get to is:

<VALUE-OF>if(row["Add1"] == "") {"";}else{row["Add1"]+", \n";}</VALUE-OF> <VALUE-OF>if(row["Add2"] == "") {"";}else{row["Add2"]+", \n";}</VALUE-OF> <VALUE-OF>if(row["Add3"] == "") {"";}else{row["Add3"];}</VALUE-OF>

It seems to handle it ok. The only issue now is that i cannot get the addresses to appear on a separate line. The javascript special character for new line "\n" does not seem to force the following addresses on a new line...

Any idea here please?

Thanks in advance
Karvesh

Re: Dynamic Text [message #715785 is a reply to message #715296]

Mon, 15 August 2011 10:39

Eclipse User

Try adding +"<br>" and use the format=HTML attribute:

<VALUE-OF format="HTML">if( true){
"<br>";
}</VALUE-OF>

Jason

On 8/13/2011 3:04 AM, karvesh wrote:
> Dear All,
>
> Myself again. After some searching and struggling, the nearest I could
> get to is:
>
> <VALUE-OF>if(row["Add1"] == "") {"";}else{row["Add1"]+",
> \n";}</VALUE-OF> <VALUE-OF>if(row["Add2"] == "")
> {"";}else{row["Add2"]+", \n";}</VALUE-OF> <VALUE-OF>if(row["Add3"] ==
> "") {"";}else{row["Add3"];}</VALUE-OF>
>
> It seems to handle it ok. The only issue now is that i cannot get the
> addresses to appear on a separate line. The javascript special character
> for new line "\n" does not seem to force the following addresses on a
> new line...
>
> Any idea here please?
>
> Thanks in advance
> Karvesh

Re: Dynamic Text [message #715794 is a reply to message #715785]

Mon, 15 August 2011 11:08

Eclipse User

Dear Jason

thanks for the tip. its working!

Karvesh

Previous Topic:	MySql Nested Select
Next Topic:	Question on log4j configuration for ReportEngine logs when using Viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Oct 30 00:22:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter