crosstab not repeating the rows

1 posts, 0 answers
  1. daouddajani
    daouddajani avatar
    6 posts
    Member since:
    Apr 2007

    Posted 28 Feb 2011 Link to this post

    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 ??
Back to Top