Report Services and Web Services?

Hi All,
I have spent the last few weeks working with SQL Server 2000 Reporting
Services and have gotten to the point of successfully creating EMail
Subscriptions. I now want to extend this so this process is performed
automatically, ie by clicking an 'Add me to this Reports Subscription list'
from within ur web application along side the link to run the report.
I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
thinking this might lie within Web Services, as I hear Reporting Services is
basically a collection of such WSs which the localhost reporting services
interface plugs into.
So I'm wondering if this is correct and if so how I go about plugging into
the WSs to script the creation of a Report Subscription. I'm guessing it
might be possible to create the required subscriptions and then just use the
script/WSs to add a users email to the email list for the subscription,
although I'm wondering if it'll be that simple!
Thanks in advance,
Stephen
.ive done this using the reporting services soap api (although i am
using 2005, it was available in 2000)
heres a starting point ..
http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
its not too difficult, especially if your contriving much of the
schedule type values in your app rather than having to recreate a
scheduling interface for the user.
db
http://www.osix.net
the open source institute
home of the geek programming challenges
StephenMcC wrote:
> Hi All,
> I have spent the last few weeks working with SQL Server 2000 Reporting
> Services and have gotten to the point of successfully creating EMail
> Subscriptions. I now want to extend this so this process is performed
> automatically, ie by clicking an 'Add me to this Reports Subscription list'
> from within ur web application along side the link to run the report.
> I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> thinking this might lie within Web Services, as I hear Reporting Services is
> basically a collection of such WSs which the localhost reporting services
> interface plugs into.
> So I'm wondering if this is correct and if so how I go about plugging into
> the WSs to script the creation of a Report Subscription. I'm guessing it
> might be possible to create the required subscriptions and then just use the
> script/WSs to add a users email to the email list for the subscription,
> although I'm wondering if it'll be that simple!
> Thanks in advance,
> Stephen
> .|||Thanks for the reply bb, but is this .Net, migth it be poss to plug into this
from VB6 or Classic ASP, as the app is in old school VS?!
Thanks,
Sephen
"bb" wrote:
> ive done this using the reporting services soap api (although i am
> using 2005, it was available in 2000)
> heres a starting point ..
> http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
> its not too difficult, especially if your contriving much of the
> schedule type values in your app rather than having to recreate a
> scheduling interface for the user.
> db
>
> http://www.osix.net
> the open source institute
> home of the geek programming challenges
>
>
> StephenMcC wrote:
> > Hi All,
> >
> > I have spent the last few weeks working with SQL Server 2000 Reporting
> > Services and have gotten to the point of successfully creating EMail
> > Subscriptions. I now want to extend this so this process is performed
> > automatically, ie by clicking an 'Add me to this Reports Subscription list'
> > from within ur web application along side the link to run the report.
> >
> > I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> > thinking this might lie within Web Services, as I hear Reporting Services is
> > basically a collection of such WSs which the localhost reporting services
> > interface plugs into.
> >
> > So I'm wondering if this is correct and if so how I go about plugging into
> > the WSs to script the creation of a Report Subscription. I'm guessing it
> > might be possible to create the required subscriptions and then just use the
> > script/WSs to add a users email to the email list for the subscription,
> > although I'm wondering if it'll be that simple!
> >
> > Thanks in advance,
> >
> > Stephen
> >
> > .
>