dane.woodhead

hi community, i am trying to use a case statement in sql for my report and i keep getting when null ='PUKPRN' syntax error SELECT observe.obs_pfm_10004823.obs_del_main_asor, observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, CAST(observe.obs_pfm_10004823.obs_del_lsd as DATE) as obs_del_lsd, CAST(observe.obs_pfm_10004823.obs_del_ped as DATE) as obs_del_ped, CAST(observe.obs_pfm_10004823.obs_del_hed as DATE) as obs_del_hed, observe.obs_pfm_10004823.obs_del_state, CAST(observe.obs_pfm_10004823.obs_del_led as DATE) as obs_del_led, observe.obs_pfm_10004823.obs_del_ssa_t1_title from observe.obs_pfm_10004823WHERE CASE WHEN $P{FLT_TYPE} = 'ASOR' THEN observe.obs_pfm_10004823.obs_del_main_asor = $P{FLT_VALUE} AND ( observe.obs_pfm_10004823.obs_del_pued = $P{PUED} OR observe.obs_pfm_10004823.obs_del_pted = $P{PTED} OR observe.obs_pfm_10004823.obs_del_pped = $P{PPED} OR observe.obs_pfm_10004823.obs_del_state = $P{VOLUME} OR observe.obs_pfm_10004823.obs_del_exmp = $P{VOLUME}) AND (observe.obs_pfm_10004823.obs_del_ped BETWEEN $P{PED_S} AND $P{PED_E} or observe.obs_pfm_10004823.obs_del_hed BETWEEN $P{PED_S} AND $P{PED_E}) order by observe.obs_pfm_10004823.obs_lnr_uln WHEN $P{FLT_TYPE} = 'PUKPRN' THEN observe.obs_pfm_10004823.obs_del_pukprn = $P{FLT_VALUE} AND ( observe.obs_pfm_10004823.obs_del_pued = $P{PUED} OR observe.obs_pfm_10004823.obs_del_pted = $P{PTED} OR observe.obs_pfm_10004823.obs_del_pped = $P{PPED} OR observe.obs_pfm_10004823.obs_del_state = $P{VOLUME} OR observe.obs_pfm_10004823.obs_del_exmp = $P{VOLUME}) AND (observe.obs_pfm_10004823.obs_del_ped BETWEEN $P{PED_S} AND $P{PED_E} or observe.obs_pfm_10004823.obs_del_hed BETWEEN $P{PED_S} AND $P{PED_E}) order by observe.obs_pfm_10004823.obs_lnr_uln WHEN $P{FLT_TYPE} = 'SSAT1' THEN observe.obs_pfm_10004823.obs_del_ssa_t1_title = $P{FLT_VALUE} AND ( observe.obs_pfm_10004823.obs_del_pued = $P{PUED} OR observe.obs_pfm_10004823.obs_del_pted = $P{PTED} OR observe.obs_pfm_10004823.obs_del_pped = $P{PPED} OR observe.obs_pfm_10004823.obs_del_state = $P{VOLUME} OR observe.obs_pfm_10004823.obs_del_exmp = $P{VOLUME} AND (observe.obs_pfm_10004823.obs_del_ped BETWEEN $P{PED_S} AND $P{PED_E} or observe.obs_pfm_10004823.obs_del_hed BETWEEN $P{PED_S} AND $P{PED_E}) order by observe.obs_pfm_10004823.obs_lnr_uln ELSE ( observe.obs_pfm_10004823.obs_del_pued = $P{PUED} OR observe.obs_pfm_10004823.obs_del_pted = $P{PTED} OR observe.obs_pfm_10004823.obs_del_pped = $P{PPED} OR observe.obs_pfm_10004823.obs_del_state = $P{VOLUME} OR observe.obs_pfm_10004823.obs_del_exmp = $P{VOLUME}) AND (observe.obs_pfm_10004823.obs_del_ped BETWEEN $P{PED_S} AND $P{PED_E} or observe.obs_pfm_10004823.obs_del_hed BETWEEN $P{PED_S} AND $P{PED_E}) order by observe.obs_pfm_10004823.obs_lnr_uln END

hi community i seem to be getting stuck putting an if else statement within a paramter with sql, i really need some help on this thank you if you can help. i am getting the error expecting anything but ''n''; got it anyway with this piece of code $P{FLT_VALUE}.equals("ASOR")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_main_asor = %$P!{ASOR}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": $P{FLT_VALUE}.equals("PUKPRN")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_pukprn = %$P!{PUKPRN}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": $P{FLT_VALUE}.equals("SSAT1")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_ssa_t1_title = %$P!{SSAT1}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_main_asor = %$P!{ASOR}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln "