RTC Report: show the subtotal at the end of each group

vandang

almost can finish this report except the subtotal, it doesn't show at the end of each group:

Group 1
Item1     1
Item2     2
Item3     3
Item4     4
Item5     5
 Subtotal 0

 Group 2
Item1     1
Item2     2
 Subtotal 15 (get from subtotal of Group1)

I had the code below:

Public totalRevenue As Decimal
Public Function SumUp(ByVal value As Decimal,ByVal value2 As Integer) As Decimal
  If value2 = 1 then
    totalRevenue = 0
  End If
    totalRevenue  = totalRevenue  + value
     Return totalRevenue 
End Function

The line detail was grouped by items, I use below code to call the function at the anohter textbox on this detail line

=Code.SumUp(ReportItems!Lab_Revenue.Value,RowNumber("Group_Labor"))

Then call this function at the Subtotal textbox at below line: =Code.totalRevenue

http://stackoverflow.com/questions/6993234/reporting-services-how-to-get-sum-of-values-using-reportitemstextbox1-value

vandang

Any help please

Navca

Hello, I have the same problem, Did you find the solution?

Thank you

nav_student

Did you try to use the

Last( Fields!<variable>.Value)

where <variable> is variable of the blue column.

lakshanvindana

this is actually depends on the report design.

if this a field, normally you can get sub total or total by using SUM in RTC.

clausl

Please share your Report.rldc and Dataset.xml files, as I explain here, then I will have a look at your report:

http://mibuso.com/blogs/clausl/2012/06/24/offline-preview-and-debug-reports-in-microsoft-dynamics-nav-2013/

/Claus Lundstrøm

vandang

Navca wrote:

Hello, I have the same problem, Did you find the solution?

Thank you

Hi Navca, still not yet

nav_student wrote:

Did you try to use the

Last( Fields!<variable>.Value)

where <variable> is variable of the blue column.

Thanks, I tried it but nothing change