View Full Version : programmatically getting SSRS pdf-report to download automatically (on sql-server)

January 15th, 2010, 04:24 PM
..via URL


,,,,,,,,,,,,,,,, easiest way would be ?

{{{{this is what I have so far:

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++
Module Module1

Sub Main(ByVal args As String())
Call DownloadFile("http://jme-qr1-sql01/ReportServer$scadareports?%2fConfigurationReport%2 fAlarm+Details+Report&OccupancyId=12345&rs:Command=Render&rs:Format=PDF", "C:/\Documents and Settings/\Administrator/\Desktop/\____.pdf", "JME-QR1-SQL01\Administrator", "jimmy1")
For Each arg As String In args
Next arg
End Sub

Sub DownloadFile(ByVal uri As String, ByVal destFile As String, _
Optional ByVal username As String = Nothing, Optional ByVal pwd As String = _
Dim wc As New System.Net.WebClient
If Not username Is Nothing AndAlso Not pwd Is Nothing Then
wc.Credentials = New System.Net.NetworkCredential(username, pwd)
End If

wc.DownloadFile(uri, destFile)
End Sub

End Module
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++

,,,,,,,, }}}}

furthermore... To download the output PDF that this SSRS-url returns; automatically, and this being done on the sql-server itself.... it gets to the last line and it encounters runtime-error of "The remote server returned an error: (401) Unauthorized." ....... I believe the issue is how said url is handled within the code, doing it manually works no problem......... any ideas?

Thanks in advance,

J. Espaņa

March 9th, 2011, 11:28 AM
you need to use

System.Net.CredentialCache.DefaultNetworkCredentia ls

as a credential

try this it works for me.