Hey All
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
etc ...
Report Footer:
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
Cheer guys!
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
etc ...
Report Footer:
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
Cheer guys!
2 Answers, 1 is accepted
0
Accepted
Hi Rob,
You can use a simple Table/Crosstab and Groups. You have to make sure that the Group occupies one page (if it is more than one because of the Table/Crosstab or any other dynamic data your layout will fall apart). Using the Group you can create one for each team member and you will not need a Report Book.
I have attached a sample - please review it and check if it satisfies your scenario.
All the best,
IvanY
the Telerik team
You can use a simple Table/Crosstab and Groups. You have to make sure that the Group occupies one page (if it is more than one because of the Table/Crosstab or any other dynamic data your layout will fall apart). Using the Group you can create one for each team member and you will not need a Report Book.
I have attached a sample - please review it and check if it satisfies your scenario.
All the best,
IvanY
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.
0
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Rank 2
Iron
Veteran
Iron
answered on 08 Mar 2012, 11:44 PM
Thanks
I seem to have had allot of issues with the install. The report wizard was not working and other feature. After woking on a support ticket , it is now and that has shown me the grouping options that is possible.. plus the page breaks after the group footer etc. Perfect.
I had read other forum posts where people were complaining they couldn't force a page break in a crosstab which was confirmed by telerik, so I was getting rather confused. ( nothing unusual there)
My report is built , working and sent off to the customer.. so thank you for you help!
Rob
I seem to have had allot of issues with the install. The report wizard was not working and other feature. After woking on a support ticket , it is now and that has shown me the grouping options that is possible.. plus the page breaks after the group footer etc. Perfect.
I had read other forum posts where people were complaining they couldn't force a page break in a crosstab which was confirmed by telerik, so I was getting rather confused. ( nothing unusual there)
My report is built , working and sent off to the customer.. so thank you for you help!
Rob