I have a main Report that is grouped by Date Group on (Week) . I have a sub report that has additional data that is displayed by date.
When I link the 2 based on date, my subreport only displays the starting or ending date of the week.
I want it to sum up the subreport based on the date range.
Here are the specifics - Main Report
Sorting & Grouping
Grouped - Date (Group On Week)
Type (Group on Each Value)
In type Header - txt fields, Type, (=Sum([Total])) -This so that for the type per week it will sum up the total
Sub Report
Grouped - Date (Group On Each Value)
Example - (Group On Each Value)
Type (Group on Each Value)
In type Header - txt fields, Type, (=Sum([Total]))
I want the report to look like
Week 1
Type1 - 452
Example1-400
Example2-52
Week 2
Type1-400
Example1-355
Example2-45
etc.
How can I accomplish this?
Thanks,
CT
When I link the 2 based on date, my subreport only displays the starting or ending date of the week.
I want it to sum up the subreport based on the date range.
Here are the specifics - Main Report
Sorting & Grouping
Grouped - Date (Group On Week)
Type (Group on Each Value)
In type Header - txt fields, Type, (=Sum([Total])) -This so that for the type per week it will sum up the total
Sub Report
Grouped - Date (Group On Each Value)
Example - (Group On Each Value)
Type (Group on Each Value)
In type Header - txt fields, Type, (=Sum([Total]))
I want the report to look like
Week 1
Type1 - 452
Example1-400
Example2-52
Week 2
Type1-400
Example1-355
Example2-45
etc.
How can I accomplish this?
Thanks,
CT