Attempting to send a single report to all managers with their direct reports' overdue tasks using the Assigned to ManagerID = $$USERID as a filter. So far, tests have been unsuccessful. Is there a proper way to set up & send the report?
Unfortunately, wildcard filters like $$USER.ID aren't supported in email delivery of reports. This functionality has been asked for dating back years, but never made it to the roadmap.
The closest workaround I've come up with is to set up a recurring email in Outlook that prompts the recipients to click on a link to the report in the body of the email, so they view the report in browser only and the wildcard filtering is then applied.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.