I have a report with two linked subreports, 1st linked subreport is showing a list of outstanding activities against the main top record. This is fine, I need the list and the count.
The 2nd linked subreport (which links with the main report on the same field as the first one) is a list of completed activities relating to the main top record. However, I only want the completed activities to show where the date of activity is greater than or equal to a date field on the main report?
How do I achieve this?