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 |
|
JeanneZhang
Starting Member
5 Posts |
 Posted - 2007-12-19 : 13:52:14
|
| I have some questions to consult experts.We use MS SQL Server 2005 and create the reports in SQL Server Business Intelligence Development Studio, then upload to SQL Server Report Manager (Report web server like http://webhost/Reports). The reports run ok there. My question is how to setup schedule the reports with parameters.For example, the DVD rental report is with Rental Date, Return Date, and Store Name. It will run weekly for 5 stores, and send the report by excel format and by email with dates range parameter to individual store (5 emails). And another additional request is do not send the report if it has no data.Please teach me how to implement the schedule setting on Report Manager step by step in detail.Thanks a lot for any help.Jeanne |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-19 : 13:56:27
|
| Duplicate, locking thread.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Report schedule setup