title: SSRS Group on multiple colums, total and expand
body: <p>In ssrs, I have a dataset from a query(mssql db) that returns three columns: </p>
  
  <p>dataset1</p>
  
  <pre><code>timestamp
  customer
  product
  </code></pre>
  
  <p>and I am trying to display a table that totals by timestamp(date only) and product, and the timestamp is collapsed on the date.  See example 1.</p>
  
  <pre><code>Date                   Customer      product    total
  + 07/12/2016           Max           Fork       5
  + 07/12/2016           Max           Spoon      4
  + 07/10/2016           Jim           Knife      11
  + 06/02/2016           Steve         Fork       6
  </code></pre>
  
  <p>Allowing the user to expand the Date to see rows for exact timestamp, like this...</p>
  
  <pre><code>Date                   Customer      product    total
  - 07/12/2016           Max           Fork       5
   07/12/2016 16:25:12   Max           Fork       1
   07/12/2016 13:11:02   Max           Fork       1
   07/12/2016 12:45:45   Max           Fork       1
   07/12/2016 10:33:20   Max           Fork       1
   07/12/2016 08:25:55   Max           Fork       1
  + 07/12/2016           Max           Spoon      4
  + 07/10/2016           Jim           Knife      11
  + 06/02/2016           Steve         Fork       6
  </code></pre>
  
  <p>I get pieces working here and there, but not all together. Any help would be appreciated. I'm rather new to creating tables from scratch and with complexity. Thank you.</p>