I have a data set with the following format

Faculty
Programme
Campus
Session
Retention
Progression

With an example row being

BAL
A200
FT
2006
14
12

I can create a report in the following format without any problem

2006
Retention Progression
BAL A200 FT 14 12

What I would like to get to though is

2006
BAL A200 FT Retention 14
Progression 12

I could do this in Crystal Reports without much of a problem and I could change the data to fit but neither of these are avenues I would like to consider at the moment and I am hoping that I am just missing something obvious in Webfocus.

Any help would be much appreciated.

Thanks

Ah - the formating does not help my garbled explanation.

Hopefully this works:

What I have now:

................2006
................Retention....Progression
BAL..A200..FT...14...........12


What I would like

............................2006
BAL..A200..FT..Retention....14
...............Progression..12

Dkirk,

Because I'm not entirely sure how your input data is formatted, I have assumed that all fields with their values are on the same record.
If that is the case, then here is a possible answer:

 
TABLE FILE KIRK
PRINT Retention
OVER  Progression
ACROSS Session  AS ''
BY    Faculty   AS ''
BY    Programme AS ''
BY    Campus    AS ''
END

Hope this helps ...

Thanks that is getting there. There are two points which I didn't put in my example which are that I need to summarise the Retention and Progression fields and there may be more than just these two.

Your help is much appreciated

I don't know how comfortable with WebFOCUS you are but this task seems perfectly suited to the MacGyver Technique or an alternate master with an OCCURS.

Go up to the Advanced Search and type in MacGyver to get details. This technique will allow you to write multiple rows of output for each row of input such that you could create two fields, a label field that would contain 'Regression' or 'Progression' and a count field that would contain the numbers that you needed to sum. You would hold that and it would be a simple task after that to SUM CNTFLD
BY FACULTY BY PROGRAMME BY CAMPUS BY LABELFLD ACROSS SESSION.

Check it out and see what you can do with it.

Thank you both for your help I shall do some reading up and let you know how I get on

dirk
put your output examples between [ code ] tags
(the red pointy brackets on posting toolbar) so they remain fixed format and don't execute any html you may wish to put in..
makes it easier for us Pointy heads to read.