quote:

Originally posted by Waz:
Can you give an example of the source data structure and the resulting output ?

 
-* File car_across.fex
TABLE FILE CAR
PRINT
     CAR.SPECS.LENGTH AS ''
     CAR.SPECS.MPG AS ''
ACROSS LOWEST CAR.ORIGIN.COUNTRY AS ''
ACROSS LOWEST CAR.COMP.CAR AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BACKCOLOR='WHITE',
$
TYPE=ACROSSVALUE,
     ACROSS=2,
     BACKCOLOR='WHITE',
$
ENDSTYLE
END

TABLE FILE CAR
PRINT
     LENGTH
     MPG
COMPUTE CARNO/I9 = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF CAR EQ LAST CAR THEN LAST CARNO ELSE LAST CARNO +1 ;
COMPUTE COLNO/I9 = IMOD(CARNO+1,2,COLNO)+1 ;
BY COUNTRY
BY CAR
ON TABLE HOLD AS TMP_SWIM
END

-*EXIT
TABLE FILE TMP_SWIM
PRINT
     LENGTH AS ''
     MPG AS ''
ACROSS COUNTRY AS ''
ACROSS COLNO AS '' COLUMNS 1 AND 2
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,$
TYPE=ACROSSVALUE,     ACROSS=1,     BACKCOLOR='WHITE',$
TYPE=ACROSSVALUE,     ACROSS=2,     BACKCOLOR='WHITE',$
ENDSTYLE
END

Waz...

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

quote:

Originally posted by Waz:
Does this look close ?

Although I'm not sure how you want to see the Triumph data.

TABLE FILE CAR
PRINT
     LENGTH
     MPG
COMPUTE CARNO/I9 = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF CAR EQ LAST CAR THEN LAST CARNO ELSE LAST CARNO +1 ;
COMPUTE COLNO/I9 = IMOD(CARNO+1,2,COLNO)+1 ;
BY COUNTRY
BY CAR
ON TABLE HOLD AS TMP_SWIM
END

-*EXIT
TABLE FILE TMP_SWIM
PRINT
     LENGTH AS ''
     MPG AS ''
ACROSS COUNTRY AS ''
ACROSS COLNO AS '' COLUMNS 1 AND 2
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,$
TYPE=ACROSSVALUE,     ACROSS=1,     BACKCOLOR='WHITE',$
TYPE=ACROSSVALUE,     ACROSS=2,     BACKCOLOR='WHITE',$
ENDSTYLE
END

quote:

It is close but the TRIUMPH data would need to display underneath the JAGUAR and associated data LENGTH and MPG in the swim lane 'ENGLAND'. So it would like there is 3 'boxes' of data under ENGLAND.