InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:58:26 GMT20http://www.sqlservercentral.com/Forums/Topic542488-147-1.aspxIf you are using Enterprise Edition reporting services, a data-driven subscription will do this. You just have to specify a query that returns the list of userid's, dates, and email addresses.If you are not using Enterprise Edition, you will either have to create individual subscriptions or create a custom solution yourself.Tue, 29 Jul 2008 05:00:09 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic542488-147-1.aspxI have a report that shows sales figures for all our employees which we run at the beginning of each month. I need to set the report to run as a subscription automatically. The report has 3 parameter sstartdate, enddate and userid. Is there a way that you can set userid parameter to loop for all the userid and create a report for each one? or do I need to create a separate subscription for each user?? I've sorted the startdate and enddate by using these as the default parameters. =DateSerial(Year(today), month(today)+1, 1),=DateSerial(year(today), month(today), 1), Thanks in advance Dave Tue, 29 Jul 2008 04:19:05 GMTdcarpenter-708789