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.
RegardsThis 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 ?