Maneesh A N

Maneesh A N

  • NA
  • 179
  • 109.1k

get single value

Aug 31 2013 4:53 AM
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
 

Answers (1)