Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

hormy83 (Programmer) (OP)
29 Sep 08 21:47
I've got a report that is supposed to list the different managers and for each manager.  It shows a summary of all the commission that his/her employees have earned and then after that it shows the details for each employee.  This one report lists all the managers for the company one after another with their corresponding employees.

So for example if Manager 1 has Employee A who made commission of $4 and $7 and Manager 1 also has Employee B who has made commission of $5 and $4 the report should look something like this:

CODE

Mgr 1 - Summary
    Emp A    $11
    Emp B    $9
Mgr 1 – Details
    Emp A
        Sale1    $4
        Sale2    $7
    Emp B
        Sale1    $5
        Sale2    $4
Mgr 2 – Summary
    ... etc

I'm not even getting that far.  This report works just fine when I've got the two group sections and no summary.  I've got the top level (ReportSection) that has the DataStream which returns all the data for the report.  Then I've got a GroupSection that groups by manager and in the content of that I've got another GroupSection that groups by the employee.

So that report returns:

CODE

Mgr 1 – Details
    Emp A
        Sale1    $4
        Sale2    $7
    Emp B
        Sale1    $5
        Sale2    $4
Mgr 2 – Details
    ... etc

Then I add a SequentialSection to the content of the grouping by manager.  I stick the group by employee inside that sequential section and add nothing else.  This then breaks both grouping functions.  The report then turns into this:

CODE

Mgr 1 – Details
    Emp A
        Sale1    $4
Mgr 1 – Details
    Emp A
        Sale2    $7
Mgr 1 – Details
    Emp B
        Sale1    $5
Mgr 1 – Details
    Emp B
        Sale2    $4
Mgr 2 – Details
    ... etc

Does anyone have any ideas on how to get the group section to work with the sequential section?

Thanks!

 
ASG0856 (Programmer)
1 Oct 08 11:01
Why are you adding the sequential section?  Assuming your managers and their specific employees all link together, you should only need to group by manager, expecially if you want a summary of all the employees commission.  The summary would go in the 'after' frame.

Group Before
         Manager
Content
              emp1   comm
              emp1   comm
              emp2   comm
              emp2   comm
After
                  Sum(Comm)
hormy83 (Programmer) (OP)
2 Oct 08 8:57
With your suggestion it appears like it will show a grand total of the commission for the manager.  So because of that and I also need the summary at the beginning I don't think that will work.

The data that I am getting is at the detail level and I plan to have the report sum it for the summary and then loop back through it and output the details.

To try to explain better what I want the report to look like, the output I'm trying to get is this:

PAGE 1 (Summary):

CODE

Manager: Joe

Emp #    Name      Comp
123      Bob       $11
532      Sue       $9
827      Jim       $15
TOTAL:             $35

PAGE 2 and on (Details):

CODE

Manager: Joe

Employee: Bob - 123
  Sale #      Comp
  A4321       $3
  A8391       $4
  A1234       $4
  TOTAL:      $11

Employee: Sue - 532
  Sale #      Comp
  A5321       $2
  A6391       $4
  A2234       $3
  TOTAL       $9

Employee: Jim - 827
  Sale #      Comp
  A2341       $8
  A4351       $7
  TOTAL:      $15

GRAND TOTAL:  $35
 
ASG0856 (Programmer)
2 Oct 08 14:51
You could add in a memory buffer, sum the commission there, and then display as I suggested, but with the summary at the top because the summing is already done
DogCityGal (Programmer)
28 Jan 09 5:04
I recommend lookahead aggregegates in the Before frame. Don't forget to use GROUP BY so that each employee gets listed separately.
In the eRDPro Help, look in "Adding Aggregate Information" in "Developing Actuate Basic Reports".

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close