Data Layout

[Mike]

I have a table with the following data
CODE  |  VALUE
-----------------------
100      | MIKE
100      | JOHN
200      | MIKE
200      | JOHN
200      | FRED

I'd like to be able to show the data in the following form:
CODE | VALUE1 | VALUE2| VALUE3
---------------------------------------------
100     | MIKE      | JOHN    |
200     | MIKE      | JOHN    | FRED

I thought this was what a cross tab could be used for but think I'm mistaken. Does anybody know how I could achieve this?

[Hadib Ahmabi]

You can do that with nested tables. The outer will iterate through the values and the inner will show all the names for the current value. 

[Mike]

How would I get the values to fill horizontally rather than vertically as shown in my example?

[Hadib Ahmabi]

Click on the inner table in the designer and select Rotate Layout - this will make the table go horizontally.