RDLC Report - matrix table - new matrix for each record

norseny
Member Posts: 19
Hi,
Can you think of any standard NAV reports generating a new matrix for each record? Is it even possible?
I've implemented a matrix report counting the number of hours per each workday (and counting also hours per different kinds of holidays, other activities etc). It works fine for one resource (one employee). But I need to implement it for many resources, so that the report will have many pages: new page = new matrix showing working hours of the resource for each day of the month.
Right now my matrix is based on a temporary table (I am fetching the data from multiple TimeSheet tables and multiple records - time sheet is generated in NAV per week and I need the data for the whole month). I am using Integer DataItem. The layout of the report:

I would appreciate any tips on how to solve this problem. Thank you in andvance!
Can you think of any standard NAV reports generating a new matrix for each record? Is it even possible?
I've implemented a matrix report counting the number of hours per each workday (and counting also hours per different kinds of holidays, other activities etc). It works fine for one resource (one employee). But I need to implement it for many resources, so that the report will have many pages: new page = new matrix showing working hours of the resource for each day of the month.
Right now my matrix is based on a temporary table (I am fetching the data from multiple TimeSheet tables and multiple records - time sheet is generated in NAV per week and I need the data for the whole month). I am using Integer DataItem. The layout of the report:

I would appreciate any tips on how to solve this problem. Thank you in andvance!
0
Answers
-
Hi,
Report 25 "Account Schedule" is matrix report.
Report for each Account Schedule collect related lines and generates columns values by selected column layout.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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