title: RDLC filtering nested tables
body: <p>I am creating an RDLC report where the dataset consists of several datatables.  There is one parent table and several child tables.</p>
  
  <p>What I would like to do is display relevant data from each child table for each row in the parent table.</p>
  
  <p>Here is a simplified example:
  table1 = "Purchase" has columns PurhcaseID, PurchaseNumber, PurchaseDate
  table2 = "PurchasedItem" has columns PurchaseItemID, PurhcaseID, ItemDescription</p>
  
  <p>In my RDLC, I have a Purchase table grouped on PurchaseDate and would like to display the PurchasedItems for each Purchase.  The current solution uses a subreport, but I do not like this because it leaves an ugly empty space when there is no data for the subreport display.  (I would be fine with using a subreport if I could properly hide it without leaving an empty space.)</p>
  
  <p>I am not able to rewrite the stored procedure to return a single table, either.</p>
  
  <p>How are others dealing with this scenario?</p>