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!
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