I am trying to create a data driven subscription that will send a report to the client for each 'finished file'. Each night this would run and send the reports that were done that day to the client one per email. I thought I had this setup correctly but it sends me 2 emails that include the same report. Any help would be great. Is it possible to do this out of the box or am I going to have to write something to accomplish this? I need to pass the CaseID and have it print a report and send an email for each unique ID. The email that the report is supposed to go to is supplied in a table that is joined. As stated above even setting the report parameter to CaseID I am just getting 2 emails with the exact same report attached. Any help would be great. George

Hi George, From your scenario, you have received 2 emails with the same report. Could you please make sure are the two emails based on two different unique IDs? If the two Emails are based on two different IDs, I am afraid we cannot do something to avoid receiving the same Emails. If not, before pass the ID to report, we should filter the ID using T-SQ like this example: Select Distinct ID… From Table. If I misunderstanding please feel free to let me know. Thanks, Eileen