CR won't allow dynamic columns...as that would imply that the schema is changing, and CR doesn't like that.
What you can do is using a stored procedure, return 2 tables. the first table has the data, with values for each of the columns, the second table has the name of the columns....
or you could do a crosstab style report,
or actually looking at the sample a bit closer,
the stored proc could return the names of the columns for each employee in a 'header' table and the data in a 'detail' table that is linked by the employeeID or something like that .
Hope one of these ideas helps.
IP Logged
