title: Matrix or Cross Tab report with single field for both Column and Row group
body: <p>I am trying to create a report of Matrix but I am not sure it is possible to achieve a matrix in SSRS or Crystal Report.</p>
  
  <p>Table<br>
      Subject     Student#<br>
      English     10000<br>
      English     10001<br>
      English     10002<br>
      Math        10001<br>
      Math        10002<br>
      Math        10003<br>
      Math        10004
      Science     10000<br>
      Science     10001<br>
      Science     10007  </p>
  
  <p>I like to create a matrix report as below. It will show student counts in both subjects.<br>
       ----------           English     Math    Science<br>
       English     -- 3    ----------       2 -----       2<br>
       Math__      --  2   ----------        4 -----       1<br>
       Science     --2     ----------      1  -----      3  </p>
  
  <p>But both Crystal report and SSRS show only numbers in the meeting cells of the same subject. For example, 3 for English 4 for Math 3 for Science. all the rest cells show 0.</p>