hi, I'm trying to take the value date from the database but it displays the default date To avoid it, i wish to display it as N/A here is the jrxml file <?xml version="1.0" encoding="UTF-8"?>select distinct substring (flt.PORT_S,1,2) as PORT_S,flt.LEAD_ATRIAL_SUMMARY_S,flt.LEAD_LV_SUMMARY_S,flt.LEAD_RV_SUMMARY_S,(select pgt.DEVICE_TYPE_S</div><div>from proc_generator_tbl pgt,followup_tbl ft,procedure_tbl pt where ft.FOLLOWUP_ID_I=$P{Subreport_Five} and pt.pacenet_ID_S=ft.PACENET_ID_S</div><div>and pgt.PROCEDURE_ID_I=pt.PROCEDURE_ID_I and pgt.PROCEDURE_ID_I=(</div><div> select pit.PROCEDURE_ID_I from proc_introduction_tbl pit,procedure_tbl pt,followup_tbl ft where</div><div> ft.FOLLOWUP_ID_I=$P{Subreport_Five} and pit.PROCEDURE_DATE_D = (select PROCEDURE_DATE_D from proc_introduction_tbl where PROCEDURE_ID_I =</div><div>(select top 1 pit.PROCEDURE_ID_I from proc_introduction_tbl pit,procedure_tbl pt,</div><div>followup_introduction_tbl fit,followup_tbl ft where pit.PROCEDURE_ID_I=pt.PROCEDURE_ID_I</div><div>and fit.FOLLOWUP_ID_I=$P{Subreport_Five} and pt.pacenet_ID_S=ft.PACENET_ID_S and fit.FOLLOWUP_ID_I=ft.FOLLOWUP_ID_I</div><div>and pit.PROCEDURE_DATE_D < fit.DATE_D order by PROCEDURE_ID_I desc ))</div><div>and pt.pacenet_ID_S=ft.PACENET_ID_S and pt.PROCEDURE_ID_I=pit.PROCEDURE_ID_I) and pgt.GEN_HW_STATE='IMPLANTED')as device , isnull(flt.IMPLANTDATE_D,'')as IMPLANTDATE_D,isnull(flt.MANUFACTURER_S,'')as MANUFACTURER_S ,isnull(flt.MODELNAME_S,'')as MODELNAME_S,isnull(flt.MODELNUMBER_S,'')as MODELNUMBER_S,isnull(flt.LOCATION_S, '')as LOCATION_S,</div><div>(select [dbo].[GET_FUN_CAPTURETHRESHOLD_LEAD](flt.FOLLOWUP_ID_I,FLT.PORT_S)) as Threshold,(select [dbo].[GET_FUN_LEAD_INTRINSIC_AMPLITUDE](flt.FOLLOWUP_ID_I,FLT.PORT_S)) as Sensing</div><div>,(select [dbo].[GET_FUN_LEAD_IMPEDANCE_VALUES](flt.FOLLOWUP_ID_I,FLT.PORT_S))as IMPEDANCE_VALUE_S,isnull(flione.IMPEDANCE_VALUE_S,'') as IMPEDANCE_VALUE_ONE,</div><div>isnull(flitwo.IMPEDANCE_VALUE_S,'') as IMPEDANCE_VALUE_TWO from followup_lead_tbl flt</div><div> left join followup_lead_impedance_tbl flione on flione.FOLLOWUP_ID_I=flt.FOLLOWUP_ID_I</div><div> and flione.MANUFACTURER_S=flt.MANUFACTURER_S and flione.MODEL_NAME_S=flt.MODELNAME_S</div><div> and flione.MODEL_NUMBER_S=flt.MODELNUMBER_S and flione.PORT_S='HV-RVport'</div><div> LEFT join followup_lead_impedance_tbl flitwo on flitwo.FOLLOWUP_ID_I=flt.FOLLOWUP_ID_I</div><div> and flitwo.MANUFACTURER_S=flt.MANUFACTURER_S and flitwo.MODEL_NAME_S=flt.MODELNAME_S</div><div> and flitwo.MODEL_NUMBER_S=flt.MODELNUMBER_S and flitwo.PORT_S='HV-SVCPort'</div><div> left join followup_lead_intrinsic_amplitude_tbl fliat on fliat.FOLLOWUP_ID_I=flt.FOLLOWUP_ID_I</div><div> and fliat.PORT_S=flt.PORT_S</div><div> left join followup_reports_tbl frt on frt.FOLLOWUP_ID_I=flt.FOLLOWUP_ID_I</div><div> left join followup_lead_impedance_tbl fli on</div><div> fli.MANUFACTURER_S=flt.MANUFACTURER_S and fli.MODEL_NAME_S=flt.MODELNAME_S</div><div> and flt.FOLLOWUP_ID_I=fli.FOLLOWUP_ID_I</div><div> and fli.MODEL_NUMBER_S=flt.MODELNUMBER_S and fli.PORT_S=flt.PORT_S</div><div> left join devicesport dp on dp.devices_s=devices_s and flt.PORT_S=dp.ports_s</div><div>where flt.FOLLOWUP_ID_I=$P{Subreport_Five} and flt.PORT_S!='Not connected'</div><div>UNION</div><div>select ports_s AS PORT_S,</div><div> 'N/A' AS LEAD_ATRIAL_SUMMARY_S,</div><div> 'N/A' AS LEAD_RV_SUMMARY_S,</div><div> 'N/A' AS LEAD_RV_SUMMARY_S,</div><div>devices_s AS devices_s,</div><div>'' AS MANUFACTURER_S,</div><div>'' AS IMPLANTDATE_D,</div><div>'' AS MODELNAME_S<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS MODELNUMBER_S<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS LOCATION_S<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS Threshold<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS Sensing<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS IMPEDANCE_VALUE_S<span class="Apple-tab-span" style="white-space:pre"> </span>,</div><div>'' AS IMPEDANCE_VALUE_ONE,</div><div>'' AS IMPEDANCE_VALUE_TWO</div><div>from devicesport where devices_s IN (select pgt.DEVICE_TYPE_S</div><div>from proc_generator_tbl pgt,followup_tbl ft,procedure_tbl pt where ft.FOLLOWUP_ID_I=$P{Subreport_Five} and pt.pacenet_ID_S=ft.PACENET_ID_S</div><div>and pgt.PROCEDURE_ID_I=pt.PROCEDURE_ID_I and pgt.PROCEDURE_ID_I=(</div><div> select pit.PROCEDURE_ID_I from proc_introduction_tbl pit,procedure_tbl pt,followup_tbl ft where</div><div> ft.FOLLOWUP_ID_I=$P{Subreport_Five} and pit.PROCEDURE_DATE_D = (select PROCEDURE_DATE_D from proc_introduction_tbl where PROCEDURE_ID_I =</div><div>(select top 1 pit.PROCEDURE_ID_I from proc_introduction_tbl pit,procedure_tbl pt,</div><div>followup_introduction_tbl fit,followup_tbl ft where pit.PROCEDURE_ID_I=pt.PROCEDURE_ID_I</div><div>and fit.FOLLOWUP_ID_I=$P{Subreport_Five} and pt.pacenet_ID_S=ft.PACENET_ID_S and fit.FOLLOWUP_ID_I=ft.FOLLOWUP_ID_I</div><div>and pit.PROCEDURE_DATE_D < fit.DATE_D order by PROCEDURE_ID_I desc ))</div><div>and pt.pacenet_ID_S=ft.PACENET_ID_S and pt.PROCEDURE_ID_I=pit.PROCEDURE_ID_I) and pgt.GEN_HW_STATE='IMPLANTED') AND ports_s NOT IN ( SELECT PORT_S FROM followup_lead_tbl WHERE followup_lead_tbl.FOLLOWUP_ID_I = $P{Subreport_Five} )select * from followup_tbl where followup_id_i=$P{Subreport_Five}$P{Subreport_Five}$P{REPORT_CONNECTION}Port$F{PORT_S}.equals("A port")?"A":$F{PORT_S}.equals("RV port")?"RV":$F{PORT_S}.equals("LV port")?"LV":$F{PORT_S}.equals("N/")?"N/A":$F{PORT_S}.equals("RA")?"RA & RV":$F{PORT_S}Lead($F{MANUFACTURER_S}.length()>0?$F{MANUFACTURER_S}:"")+($F{MANUFACTURER_S}.length()>0 && $F{MODELNUMBER_S}.length()>0?" / "+</div><div>$F{MODELNUMBER_S}:$F{MODELNUMBER_S})+($F{MANUFACTURER_S}.length()>0 && $F{MODELNUMBER_S}.length()>0 && $F{MODELNAME_S}.length()>0?</div><div>" / "+$F{MODELNAME_S}:$F{MODELNAME_S})+($F{MANUFACTURER_S}.length()>0 && $F{MODELNAME_S}.length()>0 && $F{MODELNUMBER_S}.length()>0 &&</div><div>$F{LOCATION_S}.length()>0?" / "+$F{LOCATION_S}: $F{LOCATION_S})+($F{MANUFACTURER_S}.isEmpty() && $F{MODELNAME_S}.isEmpty() && $F{MODELNUMBER_S}.isEmpty() &&</div><div>$F{LOCATION_S}.isEmpty()?"Not connected":"")implant Datenew java.text.SimpleDateFormat("yyyy - MM - dd").format($F{IMPLANTDATE_D}) Threshold ($F{Threshold}==null)||($F{Threshold}=="")?"N/A":$F{Threshold}.replaceAll(";","n")sensing ($F{Sensing}.equals(""))?"N/A":$F{Sensing}.replaceAll(";","n")impedance(($F{IMPEDANCE_VALUE_S}==null)||($F{IMPEDANCE_VALUE_S}.contentEquals(""))) ? "N/A" : ($F{IMPEDANCE_VALUE_S}.replaceAll("om","Ω")+" ").replaceAll(";","n")HV impedance ($F{IMPEDANCE_VALUE_ONE} && $F{IMPEDANCE_VALUE_TWO}==null)?"N/A":($F{IMPEDANCE_VALUE_ONE}==null || $F{IMPEDANCE_VALUE_ONE}.isEmpty() ?"":" HV "+$F{IMPEDANCE_VALUE_ONE}+" Ω ")+($F{IMPEDANCE_VALUE_TWO}==null ||$F{IMPEDANCE_VALUE_TWO}.isEmpty() ?"N/A":($F{IMPEDANCE_VALUE_ONE}.length()>0?" / ":"")+"SVC "+$F{IMPEDANCE_VALUE_TWO}+" Ω ")Check summary($F{PORT_S}.equals("A ")?$F{LEAD_ATRIAL_SUMMARY_S}:($F{PORT_S}.equals("LV")?$F{LEAD_LV_SUMMARY_S}:$F{LEAD_RV_SUMMARY_S}))
