Jump to content
  • Domain calculated fields - The expression was only partially recognized


    Friendly User
    • Features: Domains Product: JasperReports® Server

    Scenario:

    You are creating a calculated field, you have an expression like this:

    Then i tried
    IF( someField1 < 1 AND someField2 > 0, 'yes',
    IF(someField1> 5 AND someField2 < 4, 'yes', 'no'
    )
    )

    When you hit validate, the validation fails, it says the The expression was only partially recognized. What to do in this situation?

    Solution:

    1. AND needs to be all lowercase - and
    2. You need to include table names for the fields. Best way to make sure your field will be recognized is to double click on it in the fields panel while your editor is open. It will add the field with table name directly into your expression.
    3. The whole expression needs all to be one line

    User Feedback

    Recommended Comments

    There are no comments to display.



    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...