# 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) = 3800This 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) = 3800This 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