Last post Aug 20, 2014 09:35 AM by PatriceSc
Aug 20, 2014 07:14 AM|shriniwasshukla|LINK
I have data like this from view
name dateofpayment payableamount nonpaybaleamount totalamount amountdiscription
John 12/08/2012 23 44 67 discription1
John 1/08/2012 23 44 67 discription1
John 19/08/2012 23 44 67 discription1
Tom 16/08/2012 23 44 67 discription1
Tom 26/08/2012 23 44 67 discription1
Tom 9/08/2012 23 44 67
I have to create report like this
dateofpayment payableamount nonpaybaleamount totalamount
12/08/2012 23 44 67
All Payable amount by name
All noPayable amount by name
I have to create same layout for all name data.Please suggest me how I can achieve this in rdlc.
Aug 20, 2014 09:35 AM|PatriceSc|LINK
Unclear. For the first point it seems you select just a single line. Based on which criteria. It seems you would just need a where clause?
For the later one it seems you select a single line (this is 23 rather than 22 that you want) and one or to columns ???
The issue is that you have basically the same amount and description on all lines so it's hard to understand what you want. Try perhaps to explain this in plain English.
Basically if not done look at WHERE or GROUP BY for the db you are using :
Or is the problem in using RS itself. Have you seen