sql server reporting services: Creating More Than One Subscription -- sql server reporting services

Creating More Than One Subscription

A. Robinson
2/28/2007 9:29:04 AM

sql server reporting services:

I have just deployed about 75 reports to my Reporting Services instance. I
now need to create subscriptions to ALL of these reports. The recipients will
always be the same, as will the schedule.

I've already gone ahead and created a shared schedule. What I would like to
do is to create a subscription to each report without having to go into each
report one by one.

Is there any way to accomplish this in one feell swoop?

RE: Creating More Than One Subscription

Wayne Snyder
3/2/2007 2:39:25 PM

You could probably write something in the scripting language and the RS
utility... Search for Script in books on line for Reporting Services...
You'll get lots of hits, including some samples...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

[quoted text, click to view]

RE: Creating More Than One Subscription

A. Robinson
3/5/2007 1:50:03 PM

I did get lots of hits in BOL, but nothing that remotely gives me any idea on
how to even start...

I open up VS2005 and create a new VB project. When entering in some code, I
don't beleive I have the right cllass/object/whatever loaded in my project.

Could you provide some insight into what I'm missing?

And is there a programming reference anywhere specifically to address coding
..rss files? I've been looking but to no avail.

Thanks!!

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.