Try like below and let me know if this works.
select dw.C_DSC_Code,MAX(dr.d_date_report)
from tbl_dwr dr
left join TBL_DWR_DETAILS dw on dr.N_Srno=dw.N_Srno
AND dw.C_DSC_Code in ( 'D34848',
'D34796','D34799','D34801',
'D34712','D34772','D34784','D34785',
'D34787','D34816','D34765','D34779',
'D34770','D34755','D34782','D34822',
'D34687','D34817','D34759','D34777',
'D34750','D34778','D044633','D34746',
'D34749','D34819','D34747','D34769',
'D34781','D34748','D34824','D34834',
'D34776','D34670','D34763','D34757',
'D34827','D34756','D34760','D34690',
'D34739','D34716','D34768','D34825',
'D34766','D34741','D34713')
group by
dw.C_DSC_Code