Reports 2.5 question
Date: Tue, 28 Apr 1998 10:36:58 -0600
Message-ID: <6i4t2q$fj9$1_at_nnrp1.dejanews.com>
I need to create a report that has a format like this:
Page 1:
DISTRICT: SD027 Barbara Stone
- WEEKLY SHIPMENTS -- --- ACTUAL PRE-DIST ---
DEPARTMENT NUMBER RETAIL COST MRG % RETAIL COST MRG %
01 TOYS 16593 14668 55.9 124990 110277 58.9 1 - Dist. Center 10593 4668 55.9 24990 10277 58.9 2 - Direct Vendor 533 224 58.0 0 0 .0 03 HOUSEWARES 11022 1472 53.8 0 0 .0 1 - Dist. Center 1022 472 53.8 0 0 .0 2 - Direct Vendor 285 143 49.8 0 0 .0 08 BATH,CANDLES/HO 15706 12713 52.5 1915 1554 39.5 1 - Dist. Center 5706 2713 52.5 915 554 39.5 2 - Direct Vendor 337 154 54.3 2842 1280 55.0
etc. remaining depts
TOTAL ACTIVITY 38466 17172 55.4 37364 16907 54.8 1 - Dist. Center 5706 2713 52.5 915 554 39.5 2 - Direct Vendor 337 154 54.3 2842 1280 55.0
Pages 2-n:
DISTRICT: SD027 Barbara Stone STORE: 0060 Christiansburg, VA
- WEEKLY SHIPMENTS -- --- ACTUAL PRE-DIST ---
DEPARTMENT NUMBER RETAIL COST MRG % RETAIL COST MRG %
01 TOYS 16593 14668 55.9 124990 110277 58.9 1 - Dist. Center 10593 4668 55.9 24990 10277 58.9 2 - Direct Vendor 533 224 58.0 0 0 .0 03 HOUSEWARES 11022 1472 53.8 0 0 .0 1 - Dist. Center 1022 472 53.8 0 0 .0 2 - Direct Vendor 285 143 49.8 0 0 .0 08 BATH,CANDLES/HO 15706 12713 52.5 1915 1554 39.5 1 - Dist. Center 5706 2713 52.5 915 554 39.5 2 - Direct Vendor 337 154 54.3 2842 1280 55.0
etc. remaining depts
TOTAL ACTIVITY 38466 17172 55.4 37364 16907 54.8 1 - Dist. Center 5706 2713 52.5 915 554 39.5 2 - Direct Vendor 337 154 54.3 2842 1280 55.0
Basically, the lines that read "01 TOYS" are department totals for the two lines that appear after. The "TOTAL ACTIVITY" section is the total of all departments and subclasses. Pages 2-n are one page per store. So far, this is all straight forward for me.
Where I'm stuck is getting a district (n number of stores per district) total page at the beginning. It also needs department totals and page totals.
Can I do this without having two queries in the Data model? I've thought of creating a bunch of summary and formula columns but that won't work because I won't know how many deparments there are.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 28 1998 - 18:36:58 CEST