CODEWITHSUNDEEP
sqloracle-databasecheckboxbirt
nayakam
nayakam

Reputation: 4249

Convert Check box boolean value to string in BIRT 4.1?

In BIRT, How to cast the check box boolean report parameter to string value so string value can be passed to report sql parameter query from oracle database? Thanks.

Upvotes: 0

Views: 1316

Answers (1)

Dominique
Dominique

Reputation: 4332

Set a default value expression instead of linking this query parameter to a report parameter, as shown below. For example if we want to set "0" when false and "1" when true use an expression like 

params["myBooleanCheckbox"].value==null || !params["myBooleanCheckbox"].value?"0":"1";

enter image description here

Upvotes: 3

Related Questions