DEFINE FILE CAR
CAR_COUNT/D6S = 1;
END
TABLE FILE CAR
SUM
CAR_COUNT
BY SEATS AS 'Seats'
ROWS 1 OVER 2 OVER 3 OVER 4 OVER 5
ACROSS COUNTRY AS 'Country' COLUMNS 'JAPAN' AND 'ITALY' AND 'FRANCE'
END

The "AS 'Seats'" is ignored. Anyone know how to provide a column title for a column controlled by ROWS ... OVER ...?

Thanks,

quote:

DEFINE FILE CAR
CAR_COUNT/D6S = 1;
END
TABLE FILE CAR
SUM
CAR_COUNT
BY SEATS AS 'Seats'
ROWS 1 OVER 2 OVER 3 OVER 4 OVER 5
ACROSS COUNTRY AS 'Country' COLUMNS 'JAPAN' AND 'ITALY' AND 'FRANCE'
END

I'm not familiar with the 'ROWS' option, why are you using it? To show all possible seat numbers that could occur?

I am creating a report to show all possible countries and all possible seats.

COLUMNS ... AND ... does that for ACROSS.

ROWS ... OVER ... does that for BY.

It seems illogical that AS '...' works for ACROSS COLUMNS, but it does not work for BY ... ROWS

Cheers,

quote:

I am creating a report to show all possible countries and all possible seats.

COLUMNS ... AND ... does that for ACROSS.

ROWS ... OVER ... does that for BY.

I learned a new thing. I looked it up in the manual, one of the comments says 'the name of the sort field is not included in the report' which is probably why the AS doesn't work, so the big questions is why can't we give the row a column title?

Probably the same reason as you do not get a column heading for the field used in the FOR syntax in FML - not that I know the reason of course. Just surmising that it's probably linked

T

I have quite a few issues I'd like to see fixed before getting fancy new accordion thingies and the like.