pavanrp284
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by 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
