I've got a report that's grouped by delivery date (by week) by orders that are in production but not yet invoiced.
In the group footer I've got total dollar values for orders that are completed, and the total amounts for orders that are in production but not yet invoiced.

Now I've added a subreport that I would like to show all orders that have delivery dates (even those that are invoice) and their totals.

My problem is that when i link the subreport to the main report by delivery date, it only shows the date that is the first on that shows up for the week.

How do I link the subreport to the main report by the week?


Thanks for the help