crosstab not repeating the rows

[daouddajani]

My crosstab in a sales report is not repeating the rows. it is only giving me the information of one sales person. i debug the Linq datasource and for sure it has values for all the sales personal.

The need crosstab should be like this

Sales person/Week | Week1 | Week2 | week3
empl 1                     | 1000    |  3000   | 5000
empl 2                     | 1050    |  500     | 4000
empl 3                     | 1500    |  6000   | 3000

but its only showing:

Sales person/Week | Week1 | Week2 | week3
empl 1                     | 1000    |  3000   | 5000

any idea ??