brian.berrelez

Members

Community Answers

brian.berrelez's post in Error Evaluating Decimal Value was marked as the answer August 3, 2017

<conditionalStyle> <conditionExpression>
<![CDATA[new Boolean($F{AVERAGE_BALANCE}.compareTo(BigDecimal.ZERO) < 0 ? Boolean.TRUE : Boolean.FALSE)]]>
</conditionExpression>
<style forecolor="#FF0000"/>
</conditionalStyle>
[/code]
brian.berrelez's post in Set Additional Parameter Values in JRXML File based on Primary Input was marked as the answer July 25, 2017

Found my problem!
SELECT CASE $P{Month} WHEN 1 THEN '2017-11-30' WHEN 2 THEN '2017-12-31' WHEN 3 THEN '2017-01-31' WHEN 4 THEN '2017-02-28' WHEN 5 THEN '2017-03-31' WHEN 6 THEN '2017-04-30' WHEN 7 THEN '2017-05-31' WHEN 8 THEN '2017-06-30' WHEN 9 THEN '2017-07-31' WHEN 10 THEN '2017-08-31' WHEN 11 THEN '2017-09-30' WHEN 12 THEN '2017-10-31' END AS StartDate,CASE MONTH(CURRENT TIMESTAMP) WHEN 1 THEN '2017-12-30' WHEN 2 THEN '2017-01-30' WHEN 3 THEN '2017-02-27' WHEN 4 THEN '2017-03-30' WHEN 5 THEN '2017-04-29' WHEN 6 THEN '2017-05-30' WHEN 7 THEN '2017-06-29' WHEN 8 THEN '2017-07-30' WHEN 9 THEN '2017-08-30' WHEN 10 THEN '2017-09-29' WHEN 11 THEN '2017-10-30' WHEN 12 THEN '2017-11-29' END AS EndDateFROM core.env[/code]I wasn't evaluting the Parameter in the second CASE statement.
It works now!!!