REG: Matrix box in rdlc reports
thankesh
Member Posts: 170
Hi,
How to bring the total values for the matrix rows which has two row groups and a column group?
EG: (ROWGROUP - Monthwise)
YEAR | Team1 | Team2
JAN 10 4 4 4 8 5
FEB 2 6 4 5 4 9
Total 12 10 8 9 12 14
I tried " Σ". But it shows the sum(values) with rowgroup. But, I want to bring the total values for all the rows.
:-k
How to bring the total values for the matrix rows which has two row groups and a column group?
EG: (ROWGROUP - Monthwise)
YEAR | Team1 | Team2
JAN 10 4 4 4 8 5
FEB 2 6 4 5 4 9
Total 12 10 8 9 12 14
I tried " Σ". But it shows the sum(values) with rowgroup. But, I want to bring the total values for all the rows.
:-k
With warm regards,
Thankesh
***Learn to lead***
Thankesh
***Learn to lead***
0
Comments
-
You might need to use the Inscope Expression, see an example here on how to use it: http://balavardhanreddy.over-blog.com/article-advanced-matrix-control-in-ssrs-43729818.html
/ClauslClaus 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
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
- 328 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