AnsweredAssumed Answered

Data duplicating in Crystal report but not Toad

Question asked by ma12 on Nov 26, 2013
Latest reply on Dec 3, 2013 by ma12

Hello All,

Below query when I run in Toad is giving me correct data but when I run this via Crystal subreport the data is duplicating. This query is on subreport and main reports also have similar kind of query and it is working fine.

Thanks

Manjusha

with KIP as
(select * from CMN_LOOKUPS_V where lookup_type in ('SI_KPI_STATUS','prTaskStatus') and language_code='en')
select pr.PRPROJECTID PRJ_ID,
pr.prname,
pr.prFinish, 
pr.prStart,
PR.prcategory,
NVl(odf.si_trk_phase_status,-99) TRK_PHASE_STATUS,
L1.Name TRK_PHASE_STATUS_name,
NVl(odf.si_trk_budet_status,-99) TRK_BUDGET_STATUS,
L2.Name TRK_BUDGET_STATUS_name,
NVl(odf.si_trk_res_status,-99) TRK_RES_STATUS,
L3.Name TRK_RES_STATUS_name,
NVl(odf.si_trk_scope_status,-99) TRK_SCP_STATUS,
L4.Name TRK_SCP_STATUS_name,
NVl(odf.si_trk_dep_status,-99) TRK_DEP_STATUS,
L5.Name TRK_DEP_STATUS_name,
odf.si_trk_comment
from  PRTASK pr
inner join odf_ca_task odf on odf.id = PR.PRid
AND odf.si_status_rpt_flag = 1
left join KIP L1 on  L1.lookup_code=odf.si_trk_phase_status
left join KIP L2 on  L2.lookup_code=odf.si_trk_budet_status
left join KIP L3 on  L3.lookup_code=odf.si_trk_res_status
left join KIP L4 on  L4.lookup_code=odf.si_trk_scope_status
left join KIP L5 on  L5.lookup_code=odf.si_trk_dep_status
 
 

Outcomes