javier.ggi90

Solved it by changing ALL joins interacting with the table to Left Join.
This table had two joins with two different tables so I had to change both of them to Left, apparently Jasper detects an anomaly and resets it to default (Inner Join) if there is a design mistake.

There is a property named as "Remove line when blank", check it so it is true.
If that does not work you can try to modify your query for the report so that you have a condition as follows:
        WHERE (info1 + info2 + info3) IS NOT NULL
Cheers,
Javier

Solved the issue by upgrading JasperServer from version 6.1.0 to 6.2.0.
Apparently this is a bug with the version of the server.

Is PRIORITY a numerical value? If so try it like this: ($F{PRIORITY} == null ? 0 : $F{PRIORITY}) and make sure the variable is of a number type (BigDecimal, Integer, Double, etc)

I did not know anything about filter expressions, good to know they are there and I can try them next time so thanks for the info Wayne.
I found a "solution", I used the following:
(FIELD == Parameter or ParameterBool == 1) and (FIELD2 == Parameter2 or ParameterBool2 == 1) and ... (FIELDn == Parametern or ParameterBooln == 1)
This is something I had tried before but got errors, the catch is that this does not work in Studio or iReport, it has to be run directly in the server which I had not done before.
 
Javier

Try something like this instead:
$V{DID_BW}==0 && $V{DID_Colour}==0 ? 0 : $V{DID_Copy}/($V{DID_BW}+$V{DID_Colour})
 
? = THEN
: = ELSE
For future references, you can also nest them.