SSRS - automatically Execute & Save a report with Web Services using VBscript

Question

Post reply

SSRS - automatically Execute & Save a report with Web Services using VBscript

ismail casper

SSCrazy

Points: 2003
More actions
January 15, 2010 at 2:48 am

#214604

Good day, I need help.
Not sure what i'm thinking is possible. I recently updated a Sharpoint List using Web Services with VBscript.
I would like to in vbscript using web service to Execute & Save a SSRS report using Web Services.
I really would like this to work using Web Services with vbscript.
If not then some other idea - but i'm coding from Vbscript 3rd party app.
Please help

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Take a look at my blog entry here

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/direct-emailing-of-ssrs-reports-via-sqlclr.aspx

It may get you partially there

Clear Sky SQL
My Blog[/url]

ismail casper SSCrazy Points: 2003 More actions · Answer 2

Thank You

I read but i am restricted in deploying on the server 🙁

I can only deploy reports to a test server

I thought there where existing web services.

I'll try, is there anything else perhaps

Thank You

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Why can you only deploy to test servers? If those reports are required for the business then they deserve to be on a prod server, period.

I didn't check out the article but here's another option :

Also you can use subscriptions on the reports. The reports can be run on specidic schedule and mailed and / or saved anywhere on shared folders.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

ismail casper (1/15/2010)
Good day, I need help.
Not sure what i'm thinking is possible. I recently updated a Sharpoint List using Web Services with VBscript.
I would like to in vbscript using web service to Execute & Save a SSRS report using Web Services.
I really would like this to work using Web Services with vbscript.
If not then some other idea - but i'm coding from Vbscript 3rd party app.
Please help

You need to add your reports to ReportViewer control and add web.config section for your mail server because SSRS uses CDO a COM dll to send the mail so you need to create a way to use standard Asp.net to send the mail. Try the code in the link below.

http://www.codeproject.com/KB/aspnet/Mail_Print_ReportViewer.aspx

Kind regards,
Gift Peddie

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Hey gift... do you know of a way to export reports in SSRS straight to PDF in a loop so that I do it for all 2000 clients in the system?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 6

Ninja's_RGR'us (1/15/2010)
Hey gift... do you know of a way to export reports in SSRS straight to PDF in a loop so that I do it for all 2000 clients in the system?

I think you need to create subscription that uses the unattended account to send the PDF as attachment. That account must have permissions in the SMTP server that will deliver the subscription. Check below for the docs that covers what is needed.

http://technet.microsoft.com/en-us/library/ms160334.aspx

http://msdn.microsoft.com/en-us/library/ms159762.aspx

Kind regards,
Gift Peddie