How to display report CAR fields from the vertical to horizontal view

[Prem Lakshman]

Sample fex:

TABLE FILE CAR

PRINT CAR

FOR COUNTRY

'FRANCE'

FOOTING BOTTOM

"ITALY"

ON TABLE SUBFOOT

"ENGLAND"

ON TABLE PCHOLD FORMAT HTML

END

[Walter Brengel]

Hi Prem,

Assuming the image is showing what you want to see, this code will do it:

DEFINE FILE CAR

ACRPOS/I3 WITH CAR=IF COUNTRY EQ LAST COUNTRY THEN ACRPOS + 1 ELSE 1;

END

TABLE FILE CAR

SUM CAR

BY COUNTRY

ACROSS ACRPOS NOPRINT

END

It will create a position field (ACRPOS) that is used to go ACROSS the page and gets reset back to 1 (the first column) when the COUNTRY value changes.

Walter

[Prem Lakshman]

Hi Walter,

Great thank you,

Thanks,

Prem Lakshman