Collapsing a File

[JoaoPinto]

Hi,

Currently I have a report that looks like this

Reg Terr Mar Agent Name Days

002 2 04 DAN FINN MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
JEANNE NUCCIO MONDAY
FRIDAY
DAN FINN MONDAY
TUESDAY
FRIDAY


I would like it to look like this

Reg Terr Mar Agent Name Mon Tue Wed Thur Fri

002 2 04 DAN FINN X X X X X
JEANNE NUCCIO X X
DAN FINN X X X



Can anyone think of an easy way to do it?

 

[Siddhamalli]

If its going to be from a table then you can say as


TABLE FILE WEEK
PRINT
Reg
Terr
Mar
Agent
Name
ACROSS DAYS
END
See if this helps.
THANK YOU
Ganesh

 

[kaeserea]

Hi JoaoPinto,

You can also try it with a define:

[tt]
DEFINE FILE XYZ
CROSS/A1 = 'X';
END

TABLE FILE XYZ

PRINT CROSS

BY REG
BY TERR
BY MAR
BY AGENTNAME

ACROSS DAYS

END
[/tt]

Eva