Is there a way to run the same report with different parameter values?
I have 159 different parameter values (In other words - 159 reports to
save). I have already written a VB.NET application (with reporting
services web service) to automate the saving of these reports (by way
of pdf files).
I was wondering if there is a *better way* to do this. I thought
subscriptions would be good idea; however, I have 159 different
subscriptions to set up not a good idea! Is there a way to configure
subscriptions under SQL Server (via, jobs), so I would not have to
create a custom application using a webservice.
Thanks in advance!
TravisTry a linked report, and there is an app to help you if you go that way.
http://www.sqldbatips.com/showarticle.asp?ID=73
Reeves
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I can't help you with your issue, but maybe you can help me with mine. Im
trying to get my reports to PDF via a VB.NET application, and I'm having no
luck. If you can help maybe contact me at specialk_ca@.hotmail.com
Michael C
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||You can kick off subscriptions via sql server agent. (MS would probably not
recommend or support you if you did it). I have done this in the past to
overcome some of Reporting Service's shortcomings regarding executing
reports based on a fiscal calendar. If you're good at SQL scripting you
shouldn't have much trouble. The downside of doing it this way is that RS
creates new GUIDS for subscriptions anytime that they are updated. The sql
job's stored proc call is going to reference one of the subscription guids
and of course if you have alot of people tinkering with your subscriptions
you could have issues with reports not firing off because the guid
referenced in your job changes. In hindsight I think I could have written
the sql job to dynamically obtain the guid's it was about to execute but
I've been away from RS for almost a year and I don't remember the specifics
of it. Look on your report serverdb for the available stored procs. I
don't think the name of the execute one was too obfuscated. Good luck!
-Michael Abair
"Travis" <tswill54@.bellsouth.net> wrote in message
news:1187734326.317571.264180@.19g2000hsx.googlegroups.com...
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I read that a little too fast and my previous answer was way off.
I would think setting up a subscription would be the best, as stated in the
previous reply. Setting up 159 reports will be fun. If you want to run it
through your vb.net app you can path out to it, but then I'm not sure if you
can force the save at that point, but you might want to look at calling the
service directly from your app and then save the stream. Not sure on the
total details.
Sorry about the first post.
Reeves
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I think you can use Data Driven Subscriptions to fullfill your task.
Refer to steps involved in it from
http://msdn2.microsoft.com/en-us/library/aa225509(SQL.80).aspx
Thanks
Subhash
