Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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
Report 25 "Account Schedule" is matrix report.
Report for each Account Schedule collect related lines and generates columns values by selected column layout.
for Microsoft Partners