RB band line question

Sarah,

Thanks for all your help today !!!

Gary
Could someone please tell me what type of band line needs to be created to
give the "summary" of each selected part number and not the total summary of
the report?

Thanks,

Gary
KRG
Create a sort by PartNumber and then a group by NartNumber. Then add a
group Footer Band line. When you create aggregate fields of your summary
data, make sure you reset on PartNumber.
Create a new group for the field you want to sub total, your sorts should
follow suit. Example.

1 - group (header) by YEAR
2 - group (header) by Month
3 - group (header) by ORDER NUMBER
4 - group (header) by LINE NUMBER
5 - group (header) by RELEASE NUMBER

SORT by YEAR
SORT by MONTH
SORT by ORDER NUMBER
SORT by LINE NUMBER
SORT by RELEASE NUMBER

5 - SUBTOTAL by RELEASE NUMBER
4 - SUBTOTAL by LINE NUMBER
3 - SUBTOTAL BY ORDER NUMBER
2 - SUBTOTAL BY MONTH
1 - SUBTOTAL BY YEAR
Add band lines for each GROUP (HEADERS AND FOOTERS) that you define. I can
send an example off list if you need one.


Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: KRGENT@... [mailto:KRGENT@...]
Sent: Thursday, August 02, 2001 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB band line question

Could someone please tell me what type of band line needs to be created to
give the "summary" of each selected part number and not the total summary of
the report?

Thanks,

Gary
KRG

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]