none
Group Total in RDLC Report

    Question

  • I have a database report as shown below: I have calculated Subtotal by using Avg function.

    [PurchaseNo] [PaymentDate] [PurchaseAmount] [PaymentAmount] c1 12/3/2012 1000 200 12/4/2012 1000 500 ------------------------------------------------------------------- SubTotal 1000 700 -------------------------------------------------------------------- c2 12/3/2012 900 300 12/4/2012 900 500 ------------------------------------------------------------------- SubTotal 900 800 -------------------------------------------------------------------- Total 1900 1500

    UI should be like above, but when I run the RDLC report, the total is shown by calculating the values as (1000*2) + (900*2) = 3800

    This is shown below:

    [PurchaseNo] [PaymentDate] [PurchaseAmount] [PaymentAmount] c1 12/3/2012 1000 200 12/4/2012 1000 500 ------------------------------------------------------------------- Sub Total 2000 700 -------------------------------------------------------------------- c2 12/3/2012 900 300 12/4/2012 900 500 ------------------------------------------------------------------- Sub Total 1800 800 -------------------------------------------------------------------- Total 3800 1500

    Does any body has a clear defined solution for adding just the subtotals i.e 1000+900=1900 and assign it to the total.

    Thanks in advance!!

    Monday, May 12, 2014 9:22 AM

All replies

  • I have a database report as shown below: I have calculated Subtotal by using Avg function.

    [PurchaseNo] [PaymentDate] [PurchaseAmount] [PaymentAmount] c1 12/3/2012 1000 200 12/4/2012 1000 500 ------------------------------------------------------------------- SubTotal 1000 700 -------------------------------------------------------------------- c2 12/3/2012 900 300 12/4/2012 900 500 ------------------------------------------------------------------- SubTotal 900 800 -------------------------------------------------------------------- Total 1900 1500

    UI should be like above, but when I run the RDLC report, the total is shown by calculating the values as (1000*2) + (900*2) = 3800

    This is shown below:

    [PurchaseNo] [PaymentDate] [PurchaseAmount] [PaymentAmount] c1 12/3/2012 1000 200 12/4/2012 1000 500 ------------------------------------------------------------------- Sub Total 2000 700 -------------------------------------------------------------------- c2 12/3/2012 900 300 12/4/2012 900 500 ------------------------------------------------------------------- Sub Total 1800 800 -------------------------------------------------------------------- Total 3800 1500

    Does any body has a clear defined solution for adding just the subtotals i.e 1000+900=1900 and assign it to the total.

    Thanks in advance!!

    Hi,

    I have moved this thread to Visual Studio Report Controls forum which is to discuss reporting functionality including the integrated report designer and viewer controls for adding rich data reports to Windows Forms and ASP.NET applications.

    If this is an isssue of sql report tool, then you could post this issue in

    SQL ServerSQL Server Reporting Services, Power View  forum to get dedicated supports.

    Thanks for your understanding.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, May 13, 2014 5:31 AM