I want my report to be a drill down report, based on the following (example) tables:
What I want my report to do is show the following:
Weeknumber UserID # of Tasks this week # of Memo's this week
1 ABC 25 8
2 ABC 5 45
And I want to be able to drill down on the info, to show me the detail data, this is in a subreport (I don't see the problem there)
The problem is, that I don't know how to set this up. because I also need to filter on Users, dateranges etc, I can't make the whole query in SQL only and if I use Right Outer Join/SQL command this wouldn't work with the filters, so it seems I should treat this as different datasources.
Help is appreciated.