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!!```
• Moved by Tuesday, May 13, 2014 5:28 AM （form vb.net）More related
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.