Sum and Graph based on that sum in Rdlc Report RRS feed

  • Question

  • Hi, 

    I need to obatin a report on this format. 

    SQL =  Select Table1.Class, Table1.Section, (Table1.Quantity * Table2.Price) As Total from Table1 inner join Table2 on Table1.Item = Table2.Item where Table1.Id =1

    I have generated a report in rdlc where Section is the column, Class is the Row and Total is the details that gets filled in the report. 

     Section1 Section2

    Class1    145                 200

    Class2         150                 220

    Sum(Section1)  Sum(Section2)

    With the help of the sums from each section, i need to plot a graph with Section on the x-axis and Sum(Section) on the y-axis. I am not obtaining Sum(Section) from the database. 

    Question1) How do I get the Sum(Section) for each column. 

    Question2) How can I plot a graph with that value

    Require help urgently. 


    • Moved by Bob Wu-MT Friday, August 10, 2012 8:40 AM (From:Windows Forms General)
    Thursday, August 9, 2012 2:06 PM

All replies

  • Both Class1,Class2 are from the table. Similarly Section1, Section2 are also from the SQL Table. So any number of rows/columns are possible. 

    I tried adding Subtotal  to the row but it returned the last row values. 

    Thursday, August 9, 2012 2:47 PM
  • Hi Devaks,

    According to your description, this issue is about Report View control. I move it to the Visual Studio Report Controls Forum for better support.

    Sorry for any inconvenience this may cause.

    Best Regards,

    Bob Wu [MSFT]
    MSDN Community Support | Feedback to us

    Friday, August 10, 2012 8:40 AM