Report of "Projects" and active Tasks for each project
I have a table of "Projects" and a linked table of "Tasks"
I have a report layout, (based on the "Tasks" table, that displays my active tasks and sorts and groups them by project. Of course, if a "project" does not have an active "task", then it does not show it in the report.
I would like to print a single report that shows all of my active projects and any active tasks for each project. It would seem that I need to base the report on the "Projects" table, but then I only get one matching task per project.