July 29, 2008 at 4:19 am
I 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
July 29, 2008 at 5:00 am
If 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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply