Focal Point
[CLOSED] How to arrange photo layout

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9327020786

June 20, 2017, 02:41 AM
KingKong
[CLOSED] How to arrange photo layout
Hi ALL,

Currently when we generate the report, every photo take a whole line, it just like data records display line by line,that will waste many papers to print.
We want to arrange our photo layout to 4 photos a line, each photo wrapped with some information, such as name or ID.



Existing code like below, master file is 'STUDENT_RECORD', we print ID, photo name, i.e. XXXXX.jpg, and person name, and printing by Class groups.

TABLE FILE STUDENT_RECORD
PINRT ID
PHOTO
NAME
BY CLASS
END

Can help to advise how to achieve the purpose of 4 photos a line? thanks.

Regards

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8.2.0.1
Windows 7
June 20, 2017, 04:51 AM
Dave
perhaps you can make a 1 to 4 counter for each record and use it as across value?


_____________________
WF: 8.0.0.9 > going 8.2.0.5
June 20, 2017, 09:51 AM
susannah
like dave says, something like this
TABLE FILE STUDENT
PRINT ID PHOTO BY CLASS BY NAME
AND COMPUTE COLUMN/I1 = IF CLASS NE LAST CLASS THEN 1 ELSE IF LAST COLUMN EQ 4 THEN 1 ELSE 1 + LAST COLUMN;
AND COMPUTE ROW/I4 = IF COLUMN EQ 1 THEN 1 + LAST ROW ELSE LAST ROW;
ON TABLE HOLD
END
-RUN
TABLE FILE STUDENT
SUM ID PHOTO NAME ACROSS COLUMN
BY CLASS BY ROW
END




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
June 20, 2017, 04:58 PM
Waz
Wasn't there something that would output the report in a grid layout ?

Just can't remember the command.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 20, 2017, 05:14 PM
Waz
I think it was PAGEMATRIX


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 21, 2017, 03:17 AM
Dave
Waz,

that's PDF / PS only.


_____________________
WF: 8.0.0.9 > going 8.2.0.5
June 21, 2017, 04:29 PM
Waz
quote:
PAGEMATRIX


Yes, you are right.

Must have been thinking of something else.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!