Jump to content
Changes to the Jaspersoft community edition download ×

how to convert from field to full text format?

Recommended Posts

I have a table with a dormant stop field with yes/no values and I would like to count the yes value number and the no value number.  I have created a parameter as attached:



The problem is that I encounter this error message and I don’t know how to get around this problem


I tested these various formulas but I still encounter the same problem. help me.



Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images


please look at this topic that contains an simple example:

I tried this and it worked!

It also works with NOT

new Integer(!($F{STATUS}.equals("Completed")) ? 1 : 0)


How could it work if there is more than one condition.


($F{STATUS}.equals("InProcess") ?

Hope that helps. 

Regards TT


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...