Working on a report in SSRS that will be sent to multiple users but each user should only get their own records. In my main dataset I have a field for the distribution that I could use for grouping but I'm not exactly sure how to get it to work in a subscription. I've used the Data Driven one before but only for a single user and only so the report is sent when data exists, I've never done one with a dynamic distribution.
I tried using the main query for the data driven source but it ended up creating one e-mail per record so I ended up with 40 e-mails, all with the same attachment.