I have a report using a parameter picking up the logged in user on the network and doing trimming on it to remove the Domain part of it (Domain\UserID). The report sends missing timesheet for every user in the Division on a certain date. When you click on the report on the Report Server it works great and picks up the logged in user and their missing timesheets if there are any.
Here is the issue when I schedule the report through subscription and gets sent everyone gets my report and not their respective user ID on the network.
I have searched everywhere for options on how to do it and came up empty handed. People mentioned using Data Driven Subscription and I tried that but there is nowhere on there where you can set any parameters.
Any Help Would be greatly appreciated.