locked
Please suggest solution RRS feed

  • Question

  • User1320044578 posted

    Hi All,

    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 

                                            Name

    dateofpayment     payableamount     nonpaybaleamount           totalamount

       12/08/2012              23                      44                             67

    All Payable amount by name

    amountdiscription  payableamount     

    discription1             22

    All noPayable amount by name

    amountdiscription  payableamount     

    discription1             22

     I have to create same layout for all name data.Please suggest me how I can achieve this in rdlc. 

    Wednesday, August 20, 2014 7:14 AM

Answers

  • User753101303 posted

    Hi,

    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 : http://www.w3schools.com/sql/sql_groupby.asp and http://www.w3schools.com/sql/sql_where.asp

    Or is the problem in using RS itself. Have you seen http://msdn.microsoft.com/en-us/library/dd207019.aspx ?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 20, 2014 9:35 AM