This may be impossible, but I'm holding out hope...
I'm trying to report on project activity for my team. Each project record could have a related record in any of the following three tables: Notes, Tickets, Tasks.
Right now, the main report I have is grouped by project ID. Then I have three Details sections pulling in subreports for the Notes, Tickets and Tasks for each project. Each subreport is sorted by Create Date.
This is working alright, but what I would love to be able to do is to see all activity (Notes, Tickets, Tasks) for each project listed in chronological order, but I can't think of any possible way to do this.
I know this is a shot in the dark, but any guidance would be much appreciated.