title: Subreport parameters and grouping with Reporting Services
body: <p>First, I'll lay out the structure:</p>
  
  <p>The main report is a table variable from sql server giving form type, form 
  number, previous date (hidden), current date (hidden, though the parent grouping is using this), the difference in times, person's id (hidden), and person's full name. The main report is only for unexpected results and isn't all of the data for a given day.</p>
  
  <p>The subrepoort is totals counts of the various form types based on either the entire project (on a given day) excluding the person's id if there isn't a specific person selected or filtered by day and person's id if someone is. The subreport should be the Totals row for a given day (the intended parent group) as the main report is anomalies, the totals are for all forms done.</p>
  
  <p>I've run into a few problems:</p>
  
  <p>1) The date grouping thing is seperating based on date and time. Is there a way to drop the time component of a field for the sake of the grouping? I'm looking at <a href="http://thavash.wordpress.com/category/reporting-services/page/3/" rel="nofollow">http://thavash.wordpress.com/category/reporting-services/page/3/</a> right now and the FormatDateTime thing may be useful if it is more than just a visual change (ie I won't have a bunch of 9/25/11 groups).</p>
  
  <p>2) The subreport takes in two parameters of person and date to generate the list. I'm wondering if there is a hybrid way of passing parameters to the subreport as the date parameter is based off the parent groups (so not sure that it can be programmatically set). The person value may be able to be achieved by taking the key of the drop down list on the form. The only problem is I'm not sure how I can tell it programmatically to take the personid, but pull the date component only of the parent group.</p>