If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreports ? Please help, I'm running in circles here !
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) structu 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): Dim Categ 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. |
#2
|
|||
|
|||
Sorry, again, the formatting did tricks on me...
I'm trying once mo Dim Categ 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Displaying subreports with more than one record | franciscan | Setting Up & Running Reports | 10 | March 17th, 2005 09:31 PM |
Running Averages | GOL | General Discussion | 2 | February 23rd, 2005 10:48 PM |
Reporting the last record, with running sum | snake | New Users | 0 | February 9th, 2005 07:45 PM |
header of main report and detail (subreports) splitting | jenn | Setting Up & Running Reports | 0 | December 30th, 2004 04:40 PM |
Opening Subreports with dates | Don Sealer | Using Forms | 1 | December 28th, 2004 02:19 AM |