raskolnikov

Brilliant! Thanks for this andrewsok, everything is working now.

Thanks Kristen. I've checked and the section on the DomEL syntax doesn't really give any examples or pointers about how to implement an SQL case statement on a field. Any help on how to do this using DomEL would be greatly appreciated. For example, say I had a continuous variable 'Salary' (integer) and I wanted to define a calculated field 'SalaryBand' (string) depending on the value of 'Salary'. If 'Salary' < 10000 then 'SalaryBand = 'Low' If 'Salary' between 10000 and 40000 then 'SalaryBand' = 'Medium' If 'Salary' > 40000 then 'SalaryBand' = 'High'. Can this logic be implemented using DomEL?

Hello, apologies if this is a very basic question. I'm a complete newbie on a 30 day trial of JasperServer. I was wondering where I can get more information about the expression language used in the 'Calculated Fields' tab of the Domain design wizard. I would like to simulate an SQL case statement on a particular field. ... Case when marital_status = 'M' then 'Married' when marital_status = 'S' then 'Single' else 'Other' end ... I've tried finding more information about how to implement this logic on the online help and by referring to the public JasperServer documentation, but no joy. Please could anyone point me in the right direction?