Need help with FILTER EXPRESSION when importing from EXCEL

[jkeri]

In my Excel i have a field called 'LOCATION'.and 'TXTYPE in the Jasper report and both are defined as 'java.lang.String'.

I have a parameter called P_LOCATION and it is defined as Java.util.List.

 

My 'FILTER EXPRESSION' is

((ArrayList) $P{REPORT_PARAMETERS_MAP}.get( "P_CENTER" )).contains($F{Cardholder Identifier}.toString())

which allows the user to enter one or more calues for the parameter P_CENTER.   This is working as I expected.

But now my user wants to  also exclude  where the first two characters of TXTYPE = 'R-'

What I dont know is what the 'FILTER EXPRESSION' statement should be.

 

[szaharia]

Try

((ArrayList) $P{REPORT_PARAMETERS_MAP}.get( "P_CENTER" )).contains($F{Cardholder Identifier}.toString())  && ($F{TXTYPE} == null || !($F{TXTYPE}.startsWith("R-")))

[jkeri]

Excellent!!! thank you for your help.. greatly appreciated