Reports - Multiple tables
I have 2 related tables one called 'project' and one called 'tasks'. 'Tasks' contains multiple tasks related to indvidual projects in the 'projects' table.
My problem is
I want to generate a report of the current project on the screen at the time. Not all the reports just the current one.
Also In this report I want to show all the tasks related to this project. These tasks are also currently on the screen in a portal setup.
What is the best option to achieve this?