JOIN FILE CAR AT COUNTRY TAG O1 TO MULTIPLE FILE CAR AT COUNTRY TAG J1 AS J1 END TABLE FILE CAR PRINT O1.COUNTRY AS 'CT1' J1.COUNTRY AS 'CT2' O1.MODEL AS 'MD1' J1.MODEL AS 'MD2' COMPUTE RNK/I7=RNK + 1; ON TABLE SET ASNAME ON ON TABLE HOLD AS TTT END -RUN DEFINE FILE TTT FIELD_1/A600=CT1 || '-' | CT2; FIELD_2/A600=MD1 || '-' | MD2; ACROSS_GROUP/I7=RNK/23; -* The BY_GROUP is to put the across values on the same line by using modular division to only get the remainder BY_GROUP/I7=IMOD(RNK,23,'I7'); -* If you want it to dynamically split it can comment out the above two defines and use the below. Just change the 4 in the GROUPS_OF field to say how many columns you want. -*GROUPS_OF/I7=(&LINES/4)+1; -*ACROSS_GROUP/I7=RNK/GROUPS_OF; -*BY_GROUP/I7=IMOD(RNK,GROUPS_OF,'I7'); END TABLE FILE TTT SUM FIELD_1 FIELD_2 BY BY_GROUP NOPRINT ACROSS ACROSS_GROUP NOPRINT ENDThis message has been edited. Last edited by: Crymsyn,
TABLE FILE CAR SUM SALES BY COUNTRY IF COUNTRY EQ 'ENGLAND' ON TABLE HOLD AS MYTAB1 FORMAT HTML END TABLE FILE CAR SUM SALES BY COUNTRY IF COUNTRY EQ 'FRANCE' ON TABLE HOLD AS MYTAB2 FORMAT HTML END
-RUN -HTMLFORM BEGIN <HTML> <TABLE> <TR><TD VALIGN=TOP> !IBI.FIL.MYTAB1; <TD VALIGN=TOP> !IBI.FIL.MYTAB2; <TD VALIGN=TOP> !IBI.FIL.MYTAB3; <TD VALIGN=TOP> !IBI.FIL.MYTAB4; </TR></TABLE> </HTML> -HTMLFORM END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |