Sales Performance Report Needed

[BurnsORegan]

Here is sample data and a proposed layout for a report I am trying to construct. Please can anyone who has a thought....lend it to me....

Sample:

{Table1} // (Sales Order Header - F4201 in JDE)
Doc Num | Type |
1 SO
2 SQ

{Table2) // (Sales Order Detail - F4211)
Doc Num | Type | Line | Amount | Div | Manager | Saleman
1 SO 1 25 1 45 52
2 SQ 1 55 3 34 67
2 SQ 2 20 3 34 67
3 SO 2 45 1 47 51

{Table3} // (Sales Targets - F57 table)
Saleman | Div | Manager | Target
52 1 45 500
51 1 47 450
67 3 34 800
68 1 45 300
Proposed Report looks like:

RH
PH
GH1 Div
GH2 Manager
GH3 Saleman
GH4 Doc
Detail
GF4
GF3
GF2
GF1
PF
RF

In the RH I need to be able to graph data for the group as a whole and then the other sections become self explanatory. The result of which I need to look as follows (based on the sample data!)

(Document Detail suppressed for Drill down)

Sales Target | Sales Total
RH Group : 2050 145
GH1 Div 1 : 900 70
GH2 Manager 45 : 800 25
GH3 Saleman 52 : 500 25
GH2 Manager 47 : 450 45
GH3 Saleman 51 : 450 45
GH1 Div 3 : 800 75
GH2 Manager 34 : 800 75
GH3 Saleman 67 : 800 75

I hope this is making more sense. The problem is linking the Sales Target file (F57 or Table3) to the saleman (GH3) level and then being able to add the field and chart it. Problems I have encoutered are:

1. Not being able to chart a WhilePrinting?
2. Not being able to chart shered variables in the header
3. Not being able to summ a Count, Avg or Max field.

Variable, Sub Reports, Sub Reports from detail and from summary, I think I am stuck and not seeing the wood for the trees.

Please Help!!!

Regards

BurnsORegan

 

[Becky1]

Hi!

I'm having the same problem as you!
Noticed you got no replies. Did you manage to sort it out and if so couls you please tell me how you did it.

Thanks,

Becky