How to catch single from multiple entries
i have to make crystal report in c#,using sql 2005 LIKE BELOW MENTIONED
TEA PAPER
DATE QTY RS QTY RS
28-8-2013 2 20 2 40
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
where
TS.iAccID=@iAccID AND TS.dInvoiceDate>=@FromDate and dInvoiceDate<=@ToDate FROM tblSales TS INNER JOIN tblSalesItem SI ON TS.iSalesID=SI.iSalesID
SQL OUT PUT
SalesID Name Item Qty Rate Amount 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
4 MANEESH PEN 5 30.00 150.00 2013-08-13 00:00:00.000
4 MANEESH PAPER 2 20.00 40.00 2013-08-13 00:00:00.000