in the subreport create a formula to get the year week value (same as in your main report for the grouping)
//sr_weekofyear
datepart('ww',table.datefield)
in the main right click on the subreport and select links
select the @weekofyear field form the main report and link it to the @sr_weekofyear from the subreport
In the subreport this will appear as a part of the select statement
your overall select statement will be identical for all 7 subreports except that you will change which weekday value to limit
Edited by DBlank - 21 Apr 2015 at 6:23am
IP Logged
