This is a migrated thread and some comments may be shown as answers.

Approach advice for multipage reports

2 Answers 60 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Rob asked on 08 Mar 2012, 03:51 AM
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!

2 Answers, 1 is accepted

Sort by
0
Accepted
IvanY
Telerik team
answered on 08 Mar 2012, 02:46 PM
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
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
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
Tags
General Discussions
Asked by
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Answers by
IvanY
Telerik team
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Share this question
or