creating a subscription via an application

Hello,

I am wondering if there is some sample code out there that shows how to create a subscription for a report on reporting services via a win app or if anyone has a better suggestion. We are wanting to have a report that resides on reporting services server be sent to a client via email subscription, but do not want the client to goto the actual website that host reporting services. Thanks in advance.

John

There are SOAP APIs that lets you create subscriptions programmatically. Is that what you are looking for? See the following link for details.

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx

Thanks,

Sharmila

|||This was it. Thank you!!

Creating a Push Subscription on existing database.

My subscriber database has a subset of the tables in the Publisher but,
otherwise the schema is exactly the same.
Using the Push Subscription Wizard and the Initialize Subscription screen,
one is presented with two options: (I am using transactional publication)
-Yes, initialize the schema and data
-No, the Subscriber alreday has the schema and data
If I pick the first option, the initialization will fail because it tries to
drop the tables and views and my tables have relationships and contraints on
them.
If I pick the second option, the stored procedures used to update
(synchronize) the subcriber do not get created in the subcriber data base.
If I create a new database instead, everything works as expected.
How do I create a Push subscription where the table structure is already
there; but I do need to insure the stored procedures required by Replication
get created on the subscriber database?
Bill
William R
if you are running SQL 2k above sp1 do this in your publication database
sp_addpublication 'dummy'
sp_replicationdboption 'pubs','publish','true'
sp_addarticle
'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor','TableNameYouAr
ePublishingAndWantToGenerateAProcFor'
sp_addarticle
'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor2','TableNameYouA
rePublishingAndWantToGenerateAProcFor2'
sp_addarticle
'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor3','TableNameYouA
rePublishingAndWantToGenerateAProcFor3'
sp_addarticle
'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor4','TableNameYouA
rePublishingAndWantToGenerateAProcFor4'
sp_scriptpublicationcustomprocs 'dummy'
this will generate the procs you need in the results pane, script them out
and then issue a
sp_droppublication 'dummy'
"WhiskRomeo" <wrlucasD0N0TSPAM@.Xemaps.com> wrote in message
news:D46CC819-EFD7-47ED-B39B-BDD090DE4E62@.microsoft.com...
> My subscriber database has a subset of the tables in the Publisher but,
> otherwise the schema is exactly the same.
> Using the Push Subscription Wizard and the Initialize Subscription screen,
> one is presented with two options: (I am using transactional publication)
> -Yes, initialize the schema and data
> -No, the Subscriber alreday has the schema and data
> If I pick the first option, the initialization will fail because it tries
to
> drop the tables and views and my tables have relationships and contraints
on
> them.
> If I pick the second option, the stored procedures used to update
> (synchronize) the subcriber do not get created in the subcriber data base.
> If I create a new database instead, everything works as expected.
> How do I create a Push subscription where the table structure is already
> there; but I do need to insure the stored procedures required by
Replication
> get created on the subscriber database?
> Bill
> --
> William R
|||Hilary,
I was wondering if something like this would be the solution. Since there
are so many tables, I could use the create database option to create a dummy
subscriber and copy the procedures over to the real subcriber.
It seems rather odd, MS didn't think of such an option for the wizard though.
Thank you for your response.
Bill
"Hilary Cotter" wrote:

> if you are running SQL 2k above sp1 do this in your publication database
> sp_addpublication 'dummy'
> sp_replicationdboption 'pubs','publish','true'
> sp_addarticle
> 'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor','TableNameYouAr
> ePublishingAndWantToGenerateAProcFor'
> sp_addarticle
> 'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor2','TableNameYouA
> rePublishingAndWantToGenerateAProcFor2'
> sp_addarticle
> 'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor3','TableNameYouA
> rePublishingAndWantToGenerateAProcFor3'
> sp_addarticle
> 'dummy','TableNameYouArePublishingAndWantToGenerat eAProcFor4','TableNameYouA
> rePublishingAndWantToGenerateAProcFor4'
> sp_scriptpublicationcustomprocs 'dummy'
> this will generate the procs you need in the results pane, script them out
> and then issue a
> sp_droppublication 'dummy'
>
> "WhiskRomeo" <wrlucasD0N0TSPAM@.Xemaps.com> wrote in message
> news:D46CC819-EFD7-47ED-B39B-BDD090DE4E62@.microsoft.com...
> to
> on
> Replication
>
>
|||That is another way, but it is more work.
I would advise you however to script out the publishing database, create a
database called pub, and a database called sub.
In pub, run the creation script. Then run your publication script (changing
the publication name), and then create and push your subscription to sub.
This way your snapshot generation time will be very very fast and the impact
on your publisher will be low.
"WhiskRomeo" <wrlucasD0N0TSPAM@.Xemaps.com> wrote in message
news:AB0769C1-646E-4406-8B50-68A60BE62109@.microsoft.com...[vbcol=seagreen]
> Hilary,
> I was wondering if something like this would be the solution. Since there
> are so many tables, I could use the create database option to create a
> dummy
> subscriber and copy the procedures over to the real subcriber.
> It seems rather odd, MS didn't think of such an option for the wizard
> though.
> Thank you for your response.
> Bill
>
> "Hilary Cotter" wrote:

Creating a Param Subscription

When i attempt to create a new e-mail subscription to a report i get
the following error message:
"Subscriptions cannot be created because the credentials used to run
the report are not stored, the report is using user-defined parameter
values, or if a linked report, the link is no longer valid."
I have attempted everything to get this resolved. It works when i try
subscribing to a report that does not use any parameters. The
credentials are "stored securely in the report server" and i have the
default values set for my two parameters.
How do i get around this message in order to create a subscription?Does the report use the User object? If so then you can not subscribe to
it.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1114004323.057963.57760@.f14g2000cwb.googlegroups.com...
> When i attempt to create a new e-mail subscription to a report i get
> the following error message:
> "Subscriptions cannot be created because the credentials used to run
> the report are not stored, the report is using user-defined parameter
> values, or if a linked report, the link is no longer valid."
> I have attempted everything to get this resolved. It works when i try
> subscribing to a report that does not use any parameters. The
> credentials are "stored securely in the report server" and i have the
> default values set for my two parameters.
> How do i get around this message in order to create a subscription?
>|||I do not use the User Object.

Creating a new Subscription with RMO objects

Hi Gang,
Does anyone know how to createa a new subscription using RMO on SQL Server
2005. I'm using the beta version (Sep CTP) but SQL books online has bad
links on the doc's for doing this.
Any help will be greately appreciated,
Thanks,
--Ader.
The following link should hoperfully work better...
http://msdn2.microsoft.com/en-us/library/ms146863
HTH
-Raymond
"gonzalez" wrote:

> Hi Gang,
> Does anyone know how to createa a new subscription using RMO on SQL Server
> 2005. I'm using the beta version (Sep CTP) but SQL books online has bad
> links on the doc's for doing this.
> Any help will be greately appreciated,
> Thanks,
> --Ader.
>
>

CreateSubscription Error

I am trying to create an email subscription programmatically, so I first followed the BOL example which worked ok.
Later I tried to replace the fixed ExtensionParams array of the example with a call to the web service method GetExtensionSettings, where, for the desired delivery extension, a parameter array would first be dynamically filled with the required parameter names by the web service and then I would only have to supply the respective parameter values.
After that change, the call to the method CreateSubscription does not work, as it doesnt recognize a SendEmailToUserAlias=True parameter which is now also used for the call.
Why is that?Some properties returned by the GetExtensionSettings method are marked as
read-only and can not be passed back in during CreateSubscription calls.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"vsiat" <vsiat@.discussions.microsoft.com> wrote in message
news:853377AF-B0DC-477A-AD28-9507DC2559D8@.microsoft.com...
> I am trying to create an email subscription programmatically, so I first
followed the BOL example which worked ok.
> Later I tried to replace the fixed ExtensionParams array of the example
with a call to the web service method GetExtensionSettings, where, for the
desired delivery extension, a parameter array would first be dynamically
filled with the required parameter names by the web service and then I would
only have to supply the respective parameter values.
> After that change, the call to the method CreateSubscription does not
work, as it doesnt recognize a SendEmailToUserAlias=True parameter which is
now also used for the call.
> Why is that?
>

CreateSubscription

Hi,
I am not an expert but I want to create a subscription. Where can I find
informations? I don't understand all.
Moreover, I used Visual Stucio.NET. In my application, I have created a
webservice. I want that my application sends via e-mail the report. Must I
use CreateSubscription method? What are the stages? What must I do?Hi,
You can also create a subscription which send emails from the Report Server
web management UI
Just select the report, then go to Subscriptions tab.
Then click the "New Subscription" button to create a new subscription.
Choose the email delivery type in the next screen.
If email is not listed as an option in the delivery methods, check the
article at http://www.kodyaz.com/article.aspx?ArticleID=11 which shows the
configuration settings of email subscriptions for Reporting Services.
Eralper
http://www.kodyaz.com
"r388042" wrote:
> Hi,
> I am not an expert but I want to create a subscription. Where can I find
> informations? I don't understand all.
> Moreover, I used Visual Stucio.NET. In my application, I have created a
> webservice. I want that my application sends via e-mail the report. Must I
> use CreateSubscription method? What are the stages? What must I do?|||I have a problem. My data is shared. When I want to create a naew
subscription, I have an error:
"Subscriptions cannot be created because the credentials used tu run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the link is no longer valid".
What must I do?

CreateSubscription

Hi,
I am not an expert but I want to create a subscription. Where can I find informations? I don't understand all.
Moreover, I used Visual Stucio.NET. In my application, I have created a webservice. I want that my application sends via e-mail the report. Must I use CreateSubscription method? What are the stages? What must I do?I have a brief intro here:
http://www.odetocode.com/Articles/114.aspx

Created a subscription but doesn't run

I recently installed Reporting Services on my compute
I created Reporting Services subscriptions, but they doesn't run a
al
My reports are ok, I can display them without any problem on m
browser, and export them on pdf format. But subscription seems to b
totaly inactive
- reporting services SP1 and SP2 installe
- I tried File Share (with correct credentials) and e-mai
subscriptio
- selected schedule is "hourly", every 5 minutes (for testing
- on "Subscription Details" page, status is "New subscription" an
"Last run" column is empt
Thank you for any helHi
Is SQL Server Agent Running on your SQL Server?
This is requited at this places the jobs into the RS queue when a report is
scheduled.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"MacFly" <macfly92@.tiscali-dot-fr.no-spam.invalid> wrote in message
news:Le6dnVH9WcniQXzfRVn_vQ@.giganews.com...
>I recently installed Reporting Services on my computer
> I created Reporting Services subscriptions, but they doesn't run at
> all
> My reports are ok, I can display them without any problem on my
> browser, and export them on pdf format. But subscription seems to be
> totaly inactive.
> - reporting services SP1 and SP2 installed
> - I tried File Share (with correct credentials) and e-mail
> subscription
> - selected schedule is "hourly", every 5 minutes (for testing)
> - on "Subscription Details" page, status is "New subscription" and
> "Last run" column is empty
> Thank you for any help
>|||Yes, SQL Server Agent is Running on my SQL Server
After multiple attempts, I didn't succeed
My configuration was
SQL Server was on a server running under Windows 2003 Server
Report Server, Report Manager, Report Designer were on my own compute
(for testing), under Win X
I uninstalled Report Server + Report Manager from my XP computer, an
installed them on server running with windows 2003 server (beside SQ
Server) => it works fine
So I still have no answer, I only bypassed the problem..
If anyone has an idea, it still would be welcom|||when you change the login name the service runs under the encrypted data no
longer works. This includes the scheduling since it uses encrypted logins to
login and run the report. you will have to delete encrypted data and restart
the service.
MacFly wrote:
>Yes, SQL Server Agent is Running on my SQL Server
>After multiple attempts, I didn't succeed
>My configuration was
>SQL Server was on a server running under Windows 2003 Server
>Report Server, Report Manager, Report Designer were on my own compute
>(for testing), under Win X
>I uninstalled Report Server + Report Manager from my XP computer, an
>installed them on server running with windows 2003 server (beside SQ
>Server) => it works fine
>So I still have no answer, I only bypassed the problem..
>If anyone has an idea, it still would be welcom
--
Gene Hunter
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1