Eclipse Community Forums: BIRT » Conditional Formatting of Dynamic Text

Home » Archived » BIRT » Conditional Formatting of Dynamic Text(produces the conditional format of only on statement for all values)

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

Conditional Formatting of Dynamic Text [message #1823645]

Mon, 30 March 2020 16:28

Justin Flynt

Messages: 2
Registered: March 2020

Junior Member

I'm new to BIRT and trying to rebuild some payroll reports that previously were run from Crystal Reports. I'm using conditional formatting of dynamic text field for my IF, Then statement... but when i run the report it returns the same value for all rows (regardless of the data value), its the first value in my IF statement. I receive "SPRM" for every row, when i try to use this statement. Can anyone show me where I went wrong?

if(row["workcode:payrollID"] == "ATH","DIG","Super","Event","COGSE","PEP"){
"SPRM";
}
else if(row["workcode:payrollID"] == "XMAS?","CODW","CDDP","CALL OUT"){
"SOT1";
}
else if(row["workcode:payrollID"] == "OC"){
"SOT2";
}
else if(row["workcode:payrollID"] == "REGF"){
"REGF";
}
else if(row["workcode:payrollID"] == "HP05"){
"SHP5";
}
else{
BirtStr.right(row["workcode:payrollID"], 4);
}

Report message to a moderator

Re: Conditional Formatting of Dynamic Text [message #1823734 is a reply to message #1823645]

Wed, 01 April 2020 03:49

Colin Sutton

Messages: 121
Registered: July 2009

Senior Member

if(row["workcode:payrollID"].in ("ATH","DIG","Super","Event","COGSE","PEP")){"SPRM";}
or
if(row["workcode:payrollID"] == "ATH"||row["workcode:payrollID"] == ""DIG"||row["workcode:payrollID"] == "Super"||row["workcode:payrollID"] == "Event"||row["workcode:payrollID"] == "COGSE"||row["workcode:payrollID"] == "PEP")){"SPRM";}

Report message to a moderator

Previous Topic:	Display Consolidated data in the Last page of BIRT report
Next Topic:	How to Generate Spreadsheet with Multiple Worksheets (Tabs)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:28:32 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter