Make duplicate row records into columns

[tracisell]

Hello everyone,

I'm pretty new to webfocus and I have a database file that contains duplicate row values for courses a student is currently taking. My webfocus report lists per row:

Student #, Course 1, Section 1
Student #, Course 2, Section 2
Student #, Course 3, Section 3

and I would like it to list per row:

Student #, Course 1, Section 1, Course 2, Section 2, ..etc.

Any thoughts?

Traci

 

[FrankExp]

Consider ACCROSS:

TABLE FILE filename
PRINT section course
BY studentnr
ACCROSS period
END

Frank