Hi All,

1.could you please let me is there any way to change the column titles in ACROSS field.

2.is it possible to sort the columns in Across.

If I understand you correctly, this the following code is the one you are looking for

TABLE FILE CAR
PRINT CAR BODYTYPE
ACROSS COUNTRY COLUMNS ENGLAND AND FRANCE AND GERMANY
END
-EXIT

Hi Kamesh,

i want to change the columns names by using alias is it possible.
TABLE FILE CAR
PRINT CAR BODYTYPE
ACROSS COUNTRY COLUMNS ENGLAND AS'ENG' AND FRANCE AND GERMANY
END
-EXIT
I TRIED IN THE ABOVE MANNER BUT IT IS NOT WORKING.
IS THERE ANY OTHER CODE TO DO THIS.

THANKS,
KALYAN

Kaylan,

Think about this logically and you can work it out.

Kamesh gave you a method of controlling the across columns, so take that and then realise that you could do the same on a defined field -

DEFINE FILE CAR
  MYCOL/A20 = DECODE COUNTRY('ENGLAND' 'Eng' etc.);
END
TABLE FILE CAR
PRINT CAR BODYTYPE
ACROSS MYCOL COLUMNS 'Frnc' AND 'Eng' AND 'Germ'
END
-EXIT

You just have to give it a small amount of thought.

T

Thanks tony.

here in the same ACROSS Column i would like to calculate some of the columns row total, is it possible.

please let me know.

Thanks a lot.