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