Approach advice for multipage reports

3 posts, 1 answers
  1. Rob
    Rob avatar
    61 posts
    Member since:
    Jan 2012

    Posted 07 Mar 2012 Link to this post

    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. Answer
    IvanY
    Admin
    IvanY avatar
    417 posts

    Posted 08 Mar 2012 Link to this post

    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.
  3. Rob
    Rob avatar
    61 posts
    Member since:
    Jan 2012

    Posted 08 Mar 2012 Link to this post

    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
Back to Top