CrossTab and known number of cols

Juhas

Hi, I have to create a cross-tab report.
It should be something like:

1  2  3  4  5 ...  31  
Name1
Name2
Name3

So I know number of columns.

But the thing is that I don't have in my dataset every column.

For example:

Name1     4      [value]
Name1     5      [value]
Name2     3      [value]
Name2     5      [value]
Name2     7      [value]
Name3     4      [value]
Name3     5      [value]
Name3     6      [value]

So, what to do, to have in my report 31 columns, and when Someone doesn't have any value, just write: [-], for example:

            1         2         3           4...            ...31
Name1        -         -          -           [value] 
Name2        -         -        [value]    
Name3        -         -          -          [value]