RTC Report: show the subtotal at the end of each group
vandang
Member Posts: 101
almost can finish this report except the subtotal, it doesn't show at the end of each group:
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
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
0
Comments
-
Any help please0
-
Hello, I have the same problem, Did you find the solution?
Thank you0 -
Did you try to use the
Last( Fields!<variable>.Value)
where <variable> is variable of the blue column.0 -
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.Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
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ømClaus Lundstrøm | MVP | Senior Product Manager | Continia.com
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)0 -
Navca wrote:Hello, I have the same problem, Did you find the solution?
Thank you
Hi Navca, still not yetnav_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 change0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
