title: SSRS 2005 Subreports occasionally empty
body: <p>I have a "Parent" report that intentionally displays nothing, but queries a dataset of job numbers to be billed.  This Parent report then loops through those jobs, and passes them one by one to two SubReports.  The first SubReport is a summary of what will be billed on the job passed in.  The second SubReport is a breakdown of all the detail for that Job's invoice, Employee, Hours, Rate, etc.</p>
  
  <p>There will be roughly 400 jobs submitted by the Parent to the SubReports.  The Summary report prints beautifully for all of them.  The Detail SubReport does so in about 90 - 95% of the cases, but on some jobs it is blank, and I see the error message saying something to the effect that the SubReport cannot be displayed.  </p>
  
  <p>When researching this, the most common response is that there is a problem with the way the parameter is being passed in.  That doesn't seem to be the case here, especially given that about 380+ of the 400 jobs show the detail beautifully.  So, I ran the specific query for that SubReport to see if I actually got data for one of the offending jobs.  Yes, hundreds of rows of data, so the data is there, the single parameter is being passed.  </p>
  
  <p>What else could cause this error?  </p>
  
  <p>The report continues on past the error, so that's good, but I need these detail sheets to display as well.</p>