Today is my first day trying this reporting product and as usual , I have spent allot of time scratching my head. I'm used to that and it's part of taking on new projects and learning. ( and being self employed and having to take on new things all the time!!)
I have been looking at Demo's, reading forums and watching videos most of the day! ( along with trying things)
I normally just bash my way through things till I get it working, but since we have this great resource I thought I would try for some advice please. It should save me going down a path that wont work!.
The requirement is a report on employers performance. The user will select the month and the team.
The report layout is multiple page, with a page for each team member.
Report Header: Report for Team Member X
Dates performance data 1,performance data 2 ,performance data 3 ,total for PD , total@work
01/01/2012 A B C A+B+C+D E
01/02/2012 A C C A+B+C+D E
Total A Total B Total C Total (A+B+C+D) ,Total E
% totals A / E % totals B / E % totals C / E % totals ALL / E
I have tried the only 2 report wizards ( table and crosstab) and neither can do the grouping by page, so I asume I need to use the footer for the percentage calculations..
My assumption is that I need to create a parameterised report for the above that is passed the month and the team member ID. Then use a Report Book and dynamically add the report for each team member , passing the month and member ID
Is that the right approach or is there some way to group into pages that I cannot see?
I'm using 2012 Q1 release