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 |
|
NickStan
Starting Member
36 Posts |
 Posted - 2008-07-11 : 11:03:28
|
| I am going to start working on a project that will allow users to run any one of a number of reports at a given time and date.They will select the report type, frequency, start and end days, CC list.The report is generated from our Oracle database and then email the generated report to those on CC.I can easily create the SQL, but the problem is that we have could have hundreds (if not thousands) of reports to schedule and run. I thought about creating a DTS package per report request, but this is not possible due to the sheer numbers of reports.I can have a database record per report, with the sql code, etc. But how do I kick off a report at a certain date and time based on a database entry?I can create generic DTS report templates per report and pass parameters into the report, but I have not done this before.Suggestions welcomeThanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 22:46:10
|
| Do you use reporting service? |
 |
|
|
NickStan
Starting Member
36 Posts |
Posted - 2008-07-14 : 04:57:55
|
| We do not have Reporting Services on our server.I have read up briefly on RS and it looks promising.We are using MS SQL Server 2000, Windows Server 2003 R2, SP2.Any other prerequisites? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-14 : 22:44:33
|
| You are ready to go. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-14 : 23:01:49
|
| Use data driven subscriptions to schedule reports. |
|
|
|
NickStan
Starting Member
36 Posts |
Posted - 2008-07-17 : 10:04:16
|
| Thanks for the reply, unfortunately I have no idea on how to setup a data driven subscription. I have searched for tutorials on how to do this but cannot find anything.Do you know of any articles or tutorials that would explain how I go about this?Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 13:20:40
|
| Take a look at this:http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q1455840 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:04:53
|
| You need get RS installed first since data driven subscriptions is for RS. |
|
|
|
|
|
|
Reports Automation System