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:51
|
| I am new for MS SQL Reporting Service and 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 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-20 : 00:54:57
|
Hi Jeanne,This is actually easier than you think.I won't explain it to you in detail as you can go down many paths to achieve this (or something similar).Firstly if you are going to be delivering the reports by email then you need to ensure that the report system is configured for sending email correctly, this can be done by making use of the "Reporting Services configuration manager" Start >> Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> Reporting Services Configuration. Once you have started this application connect to the report server which you want to configure, select Email Settings and fill in the SMTP server details in the required fields, click apply when done.Secondly if the report which you want scheduled is not yet published to your report server ie http://webhost/reports (as mentioned in your question) then do so.Thirdly - this is where you set up the schedule - open the report in your web browser run it and near the top of the page is a link called "Subscriptions" - it has a blue background (normally) - click on this link. You then have the option to create a new subscription or Create a new data driven subscription - they are both similar to wizards and should be easy enough for you to figure out.I hope this helps.Duane.  |
 |
|
|
JeanneZhang
Starting Member
5 Posts |
Posted - 2007-12-20 : 09:20:10
|
| Duane,Thanks a lot for your help.One more question, how about parameters. For example, one report with dates range and store name parameters. We need send the report to the store (5 stores) with dates, and do not send empty report if no data return for the store. Thanks for any help.Jeanne |
|
|
|
sreenu9f
Yak Posting Veteran
73 Posts |
Posted - 2008-12-01 : 12:27:50
|
| Hi Jeanne; did u get any other suggestions for the data parameter and not to send when there is no result set. I am also having the same problem.Any one else please suggest.Thanks, |
|
|
|
|
|
|
|
|
Report schedule setup