Horizontal Fields

[gb1983]

I would like to produce the following (But without the dashed lines):

--------------Jan --- Feb --- Mar --- Apr ---May --- Jun ---- Jul

P.Jones -------20 --- 12 --- 12 --------45 ---12 ----87 ----- 23
A.Smith -------22 --- 11 --- 77 --------56 ---43 ---- 98 ----- 86
T.Taylor -------45 --- 54 --- 21 --------21 ---98 ---- 43 ----- 54


I am using a stored proc to retrieve the data so I cant use a cross tab as I dont want to summarize anything as the stored proc does this for me.

The problem is that I cannot print the months horizontally and I am given the following output:

P.Jones

Jan 20
Feb 12
Mar 12
etc...

A.Smith
Jan 22
Feb 11
Mar 77
etc...

Please can anyone let me know if this is possible and how if it is ?

Thanks

[brucevde]

You could still use a Cross Tab. Since the detail records are unique for the group, the Cross Tab will simply sum a single value.