SELECT  Date_format(Voucher_Date,'%d-%m-%Y') as 'Date', cast(COALESCE(sum(Gross_Total),0.00) as Decimal(10,2)) As 'Taxable Amount', cast(COALESCE(SUM(VAT_Amount),0) as decimal(10,2)) as 'Vat Amount', Cast(COALESCE(SUM(Total),0) as Decimal(10,2)) as 'Total Amount'  FROM $trans_db.Purchase_Invoice_Main WHERE `TimeStamp` >='$fromDateTime' AND `TimeStamp`<='$toDateTime'  GROUP By(Voucher_Date)