my problem is when parameter is NOT null I want to concatenate a string to parameter and show it else I want to return null to show nothing but it always showing the string part which is in my example below is HELLO even if the parameter is null
($P{PARAM_NAME} !=null ? CONCATENATE(" HELLO ",$P{PARAM_NAME}) : null)
my problem is when parameter is NOT null I want to concatenate a string to parameter and show it else I want to return null to show nothing but it always showing the string part which is in my example below is HELLO even if the parameter is null
($P{PARAM_NAME} !=null ? CONCATENATE(" HELLO ",$P{PARAM_NAME}) : null)
my problem is when parameter is NOT null I want to concatenate a string to parameter and show it else I want to return null to show nothing but it always showing the string part which is in my example below is HELLO even if the parameter is null
($P{PARAM_NAME} !=null ? CONCATENATE(" HELLO ",$P{PARAM_NAME}) : null)
my problem is when parameter is NOT null I want to concatenate a string to parameter and show it else I want to return null to show nothing but it always showing the string part which is in my example below is HELLO even if the parameter is null
($P{PARAM_NAME} !=null ? CONCATENATE(" HELLO ",$P{PARAM_NAME}) : null)
