Please, please help with this report

  • Thread starter Thread starter Alex Nitulescu
  • Start date Start date
A

Alex Nitulescu

I am not asking you to do it for me, I only need an idea to get me out of
this mess, please...

I am trying to create a report based on three tables with the following
(identical) structure: Type/Year/Month/Category/Dimension/Qty/Amount. Based
on them, I need to produce a report which would look like this: for each
Year/Month, I should have the following columns:

Dimension,
Category,

RET.Qty, - from table RET
Ret.Amount, - from table RET

NORET.Qty, - from table NORET
NORet.Amount, - from table NORET

OUT.Qty, - from table OUT
OUT.Amount. - from table OUT

The records should be grouped by Year/Month, of course, but also by
- each Category (I have three, A, B, and C)
- each Dimension (I have two, 48 and 60)

That means that for each Year/Month combination I should have 6 rows:
48 A
60 A
48 B
60 B
48 C
60 V
and for each row I should have totals of Qty and Amounts.

So for Year X/Month Y the report should look like this (where Qty is the sum
of Qty and $ is the sum of Amount):

Dimension Category RetQty Ret$ NoretQty Noret$ OutQty
Out$
_____________________________________________________________
48 A 19 20 22
38 48 93
48 B 73 93 32
19 84 92
48 C 23 19 29
20 49 16

60 A 61 91 73
35 38 81
60 B 51 15 72
83 63 66
60 C 14 32 63
77 83 61

I have tried with subreports, but I can't find the way to group & link them
properly. Can you please, please, please give me some ideas on how to do
this ?

Thank you very much.
Alex.
 
Please disregard this post - the correct one is named "Subreports ? Please
help, I'm running in circles here !"
 
Back
Top