[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | FOCUS, from INFORMATION BUILDERS |
|
| Moderator: | ZAYIUS::BROUILLETTE |
|
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
492.0. ""Appending" reports horizontally" by MISERY::BLUM_JO () Tue Jan 28 1992 17:12
I'm trying to create a report which is, in effect, 2 reports appended
horizontally. Each report uses a different datafile. There is one
field the reports share in common. This would be used for the join or
match. However, there is no relationship between the rest of the fields
from the 2 datafiles.
One report looks like (KEY_FIELD and PART_NO are sort fields):
KEY_FIELD
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
KEY_FIELD
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
KEY_FIELD
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION
The other report looks like (all the fields other than DESCRIPTION
are sort fields):
KEY_FIELD
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
KEY_FIELD
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO and PART_NO_2 are not the same. I need to get the report to
look like:
KEY_FIELD
COUNT PART_NO DESCRIPTION AGREEMENT_NO
COUNT PART_NO DESCRIPTION COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
KEY_FIELD
COUNT PART_NO DESCRIPTION AGREEMENT_NO
COUNT PART_NO DESCRIPTION COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION AGREEMENT_NO
COUNT PART_NO DESCRIPTION COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
COUNT PART_NO DESCRIPTION
COUNT PART_NO DESCRIPTION AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
PART_NO_2 DESCRIPTION
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
SERIAL_NO PART_NO_2 DESCRIPTION
AGREEMENT_NO
COST_CTR SERIAL_NO PART_NO_2 DESCRIPTION
Any ideas on how to do this?
Regards,
John
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 492.1 | Try multiple Verbs | USMFG::BHYNES | | Thu Jan 30 1992 15:47 | 7 |
| Try using multiple verb phrases.... Its in Volume 1 chapter 2 in the
focus books. The section is titled(in my book)
Using more than One Verb at a time..
bob
|