Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaveC11
Starting Member
43 Posts |
 Posted - 2008-07-29 : 06:16:58
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-29 : 11:30:41
|
| Are you using standard report viewer or customised one? |
 |
|
|
|
|
|
Userid Parameter