Linking Report / Sub Report

Joined
Sep 14, 2005
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top