Approach advice for multipage reports

3 posts, 1 answers
  1. Rob
    Rob avatar
    59 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. DevCraft banner
  4. Rob
    Rob avatar
    59 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