GetDateRangeDialog(date1, date2);
ds1:= FormatDateTime('yyyy-mm-dd',date1);
ds2:= FormatDateTime('yyyy-mm-dd',date2);
cds:=Tclientdataset.create(nil);
cds.HOSxp_Getdataset('select * from tempreport where id = "CUSTOM-Yindee"');
cds.first;
cds.assigndatatomainreport;
HbA1C_min :=cds.fieldvalues['name1'];
HbA1C_max :=cds.fieldvalues['name2'];
{cds.assigndatatoPipeLineLink1; }
cds.free;
ChangeReportSQL('select a.report_date,a.hn ,concat(c.pname,c.fname," ",c.lname) as ptname,b.lab_order_result '+
'from lab_head a '+
'left outer join lab_order b on a.lab_order_number=b.lab_order_number '+
'left outer join patient c on a.hn=c.hn '+
'where a.report_date between"'+ds1+'"and"'+ds2+'" '+
'and b.lab_order_result between '+HbA1C_min+' and '+HbA1C_max+' '+
'and b.lab_items_code="3162" order by a.report_date,a.hn ');