I have a report working in Report Designer that I would like to be able to send the Project Managers only their jobs - but when I use My Assistant it sends all jobs. I use My Assistant for notifications and it works great, but this is the first time I have tried attaching a report. How so I set up a condition in Report Designer to so it will only their jobs? My preference would be each job would be a separate attachment, but would be happy if I could get it to only send their jobs. The driving record in the report is JC Transactions.
Any help greatly appreciated !