pavanrp284

HI, Please help with below error Multiple markers at this line - mismatched input '.' expecting 'FROM' - mismatched input '<>' expecting 'THEN' - mismatched input ''CANCELLED'' expecting 'END' select shp.seq shipmentseq , case when sst.statuscode <> 'CANCELLED' then shp.shipmentuniqueid end shipmentref , shp.shipmentdate shipmentdate

Please help me with the below query. EstimateAmount is available in XXYSS_Forwarding.V_Estimations Table and ShipmentSeq, Qty, ETDDate, ETADate are available in XXYSS_Forwarding.jv_Transport_order. Data is coming from Transport_order file in jasper report, but data is not coming from V_Estimations. Please find queries for both tables below: Transport Order Query: Select SHIPMENTSEQ, QTY,ETDDATE,ETADATE from "XXYSS_FORWARDING"."JV_TRANSPORT_ORDER"where SHIPMENTSEQ = $P{P_SEQ} V_Estimations Query: Select ESTIMATEAMOUNT from "XXYSS_FORWARDING"."V_ESTIMATIONS"Where SHIPMENTSEQ = $P{P_SHIPMENTSEQ}

Hello All, When iam trying to view report in pdf fromat iam getting below error. no file association defined in your system for .pdf, please open in manually or fix association and retry. Please help with me this how to fix this error. Thanks in advance