Maneesh A N

Maneesh A N

  • NA
  • 179
  • 109.1k

How to catch single from multiple entries

Sep 2 2013 1:12 AM
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


Answers (1)