| 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 |
I have a format question:
Currently the report looks like this
TRANSACTION_NO DOCUMENT_NO
1111 ABC
XYZ
IOU
Need this format
TRANACTION_NO DOCUMENT_NO
1111 ABC XYZ IOU
There is a maximum of 3 document_no for any 1 transaction
I've tried defining columns and using across statements.
The closet I could get was an output that looked like
TRANSACTION_NO DOCUMENT_NO
1111 . . IOU
. XYZ
ABC
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 461.1 | Try this... | RDGE44::KEEGAN_9 | Tue Oct 01 1991 04:45 | 20 | |
Try this (assuming ALWAYS maximum of 3 documents per transaction) ...
TABLE FILE XXXXX
LIST DOCUMENT_NO
BY TRANSACTION_NO
ON TABLE HOLD
END
DEFINE FILE HOLD
DOC1/A3 = IF E02 EQ 1 THEN DOCUMENT_NO ELSE ' ';
DOC2/A3 = IF E02 EQ 2 THEN DOCUMENT_NO ELSE ' ';
DOC3/A3 = IF E02 EQ 3 THEN DOCUMENT_NO ELSE ' ';
END
TABLE FILE HOLD
SUM MAX.DOC1 MAX.DOC2 MAX.DOC3 BY TRANSACTION_NO
END
Regards,
Paul K
| |||||
| 461.2 | E02 is not recognized | CSLALL::COLBERT | Wed Oct 02 1991 11:14 | 1 | |
E02 is not recognized. | |||||
| 461.3 | it works for me ! | RDGE44::KEEGAN_9 | Wed Oct 02 1991 11:32 | 10 | |
Hi, again
Sorry, BUT, I've just retried the code in .1 and it works with NO problem.
(I used E02 - that's E-zero-2, because LIST, which is the resultant
fieldname might confuse FOCUS as a reserved word).
Paul K
| |||||
| 461.4 | Corrections made | CSLALL::COLBERT | Wed Oct 02 1991 11:46 | 11 | |
I made a typing error on the DEFINE FILE HOLD, I typed the original
amster file.
I then got foc error 280 - "mishmash in data types... quotation marks
may be missing"
So I changed EQ 1 to EQ '1'
EQ '2'
EQ '3'
The report print. Now I need to find why there is no data printing
to MAX.DOC1 etc. Maybe the data is really not on file.
| |||||