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 |
|
tikus
Starting Member
31 Posts |
 Posted - 2005-04-19 : 13:07:07
|
| I have several reports (very complex, running of SP) with @StartDate and @EndDate. The reports need to be scheduled weekly and Monthly. For weekly, I need @StartDate and @EndDate within a week, dates are different for each vendor. For monthly, the date range would be for a month. In Report Manager Subscription, how can i dynamically set my @StartDate and @EndDate? e.g. everything Monday to Sunday, or everything Wednesday to Tuesday, or 1st of the month to last date of the month? Thanks! |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-19 : 13:12:52
|
Have you looked at subscriptions? You can subscribe to a report but you would have to predefine when and to whom would get the report. You should also be able to access this via code, but I have no experience with this.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
tikus
Starting Member
31 Posts |
Posted - 2005-04-19 : 13:28:48
|
| Yes, I played around with the subscriptions. Like I entered "DateAdd(d, -3, @ExecutionTime)" for my @StartDate, it didn't work..... |
|
|
|
|
|
|
Dynamic Date parameters