| 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 .FOC file with the following relationships .....
PROJHDR
|
|--------|-------|-------|-------|-------|-------|-------|-------|
BENEFITS PROJTYP HDRORGS OPPPROB OUTCOME DELIVER SUCCESS PROJUPD TASKS
| |
SUB_UPD SUBTASK
All segments are Type=S1
I would like to print a report in the following format ...
Project Number : ##### [PROJHDR FIELD]
Project Name : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [PROJHDR FIELD]
Project Owner : XXXXXXXXXXXXXXXXXXXX [PROJHDR FIELD]
Benfits : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [BENEFITS FIELD]
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
.
. etc.
.
Type(s) : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [PROJTYP FIELD]
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
.
. etc.
.
And continue the same format for the rest of the segments.
I've tried using the OVER statement - but it puts the first instance of
each segment over each other ... Proj num Proj num
Proj name then Proj name
Proj ownr Proj ownr
Benfits instance 1 Benefits instance 2
Types instance 1 Types instance 2
I've also tried using a "Non-Tabular" approach and I can get it to output
in the correct format, but it will only print the first instance of
the multiple instance fields.
Can anybody help me out there ? - All suggestions are welcome as I'm running
out of ideas.
I've been placing a lot of misplaced aggression on my terminal over this
one and I don't need a visit from the SPCT ( Society for Prevention of
Cruelty to Terminals ).
Thanx,
Sharon
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 230.1 | The first step... | FERNEY::OTT | Fri Jun 30 1989 04:36 | 32 | |
Hello, Sharon. I've got no solution for the whole thing, but perhaps a start (and someone else may find more...) Put PROJHDR info in a HEADING statement Project Number : ##### [PROJHDR FIELD] Project Name : XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [PROJHDR FIELD] Project Owner : XXXXXXXXXXXXXXXXXXXX [PROJHDR FIELD] (something like : TABLE FILE... HEADING "Project Number : <number_field> </1" "Project Name : <name_field> </1" "Project Owner : <owner_field> </1" PRINT...) Then PRINT only the benefits, for example. Or only the types. This gives you not a full report but several reports with correct format for each type of info. Hope that helps, JD. | |||||
| 230.2 | THANX FOR THE RESPONSE | CHET::FOREMAN | LOOKS_EASY = NO_WAY | Fri Jun 30 1989 11:58 | 14 |
JD, Thanx for your response. This is my "compromise" solution but I'd rather not have to have 10 report pages for each project if it can be avoided. Each segment/field of information will probably only use 10-12 text lines so the rest of the page will be blank. Thanx again for replying. I originally thought what I was trying to do was probably simple and I was just too shortsighted to see it. The more people I ask, though, it seems like it must be a bit tricky for focus functionality. I'll keep plugging. Sharon | |||||