title: Matrix in crystal report
body: <p>i badly need help.
  i am new to crystal report and visual studio.</p>
  
  <p>my prof give us an assignment and i cant get the output he wants to see.</p>
  
  <p>right now i am using visual studio 2010 and crystal report
  and it doesn't show the right output.</p>
  
  <p>the data-table in my data-set is:</p>
  
  <pre><code>MALL_DESC,
  
  OUTLET_NAME,
  
  and
  
  ITEMNAME
  
  
  the datatable in my data set are also the name of columns
  in the table in our database.
  
  they are two tables that i joined together.
  
  table1: M_OUTLET
  
  table2: T_SALES_DETAIL
  </code></pre>
  
  <p>when i run my program
  my crystal report gives me output like this:</p>
  
  <pre><code>MALL_DESC            OUTLET               ITEMNAME
  
  SM LIPA            LIPA CAFE              BLUE CUPCAKE
  
  SM LIPA            LIPA CART              PINK CUPCAKE
  
  SM BACOLOD         BACOLOD CAFE           BLUE CUPCAKE
  
  SM BACOLOD           BACOLOD CART           PINK CUPCAKE
  </code></pre>
  
  <p>but the output i want is this:</p>
  
  <pre><code>MALL_DESC            OUTLET         BLUE CUPCAKE           PINKCUPCAKE 
  
  SM LIPA            LIPA CAFE               5                    12
  
  SM LIPA            LIPA CART              23                     7
  
  SM BACOLOD         BACOLOD CAFE            4                     8 
  
  SM BACOLOD           BACOLOD CART           19                     22
  </code></pre>
  
  <p>help me please
  and thank you so much.</p>
  
  <p>fionakyla</p>