SP
SELECT
TS.iAccID as iAccID,
TS.vAccName as Name,
SI.vItemName as Item,
SI.iNos as Qty,
SI.deRate as Rate,
SI.deAmount as Amount,
TS.dInvoiceDate as Date
FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID
sql output
iACCID Name Item Qty Rate Amount Invoice Date
4 MANEESH TEA 1 10.00 10.00 2013-08-28 00:00:00.000
4 MANEESH TEA 1 10.00 10.00 2013-08-28 00:00:00.000
4 MANEESH PAPER 2 20.00 40.00 2013-08-28 00:00:00.000
4 MANEESH PEN 4 30.00 120.00 2013-08-28 00:00:00.000
4 MANEESH TEA 4 10.00 40.00 2013-08-13 00:00:00.000
i need to Make report like below mentioned,when i select Customer Name As 'MANEESH',Date Time Picker Form Date'01-Aug-2013' and To Date '31-08-2013' from a Form to get CRYSTAL REPORT
Date TEA RS PEN RS
28-08-2013 2 20 4 120
13-08 2013 4 40 0 0